Use a convert request in an Optim™ interoperability service that will convert data.
Use the convert process to transform data in an extract file. When you convert data in an extract file, you can save the converted data to the same file or as a different extract file. Depending upon circumstances, it may be useful to retain the original file to maintain a consistent starting point. For example, you can create a set of extract files that contain the same data, aged to different dates, by saving the output of each conversion as a separate extract file. Conversely, you can overwrite the original extract file in order to mask sensitive data. .
Additionally, you can convert an extract (or an archive) file into a comma separated values (*.csv) file, which you can then import into a spreadsheet program or a database. The convert request allows you to select the columns from each joined table that are to be included in the file.