OAC DV - Dataflow output alternative formats to CSV

Tasha

Currently when a dataset is outputted from a DV dataflow it automatically outputs in CSV format, we often need to export these datasets to them provide to an external user (for example providing data to a regulator) so then have to reformat the data and resave as xlsx

Please either change to format automatically to xlsx or have the option to select the output format

Gabby Rubin-Oracle

I assume you are using the 'download file' option? Would it be feasible for you to export to Excel from within a Workbook table?

We do not plan to use alternative formats in the internal storage as the goal is storage and performance efficiency. We might be looking at other possible solutions for this use case.

Tasha

Thanks for the reply Gabby but unfortunately the workbook option won't work for us, we need to retain the formatting of the columns in the dataflow output, this is for our employee unique identifier which should be in text format (000000), when exported in CSV format we lose any leading 0s, as well as any columns in currency format

Gabby Rubin-Oracle

Even before the CSV, I assume that the ingestion into OAC will already remove the leading zeros, and if they survive, the Data Flow will remove them unless these are text fields that CSV should also retain. We might need a detailed example to understand this one better.