Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC DV - Dataflow output alternative formats to CSV

27
Views
3
Comments
Tasha
Tasha Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

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

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    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
    Tasha Rank 1 - Community Starter

    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
    Gabby Rubin-Oracle Admin

    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.