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

Disable automatic sorting when uploading data through a dataset

Declined
11
Views
3
Comments
Joshua Co
Joshua Co Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server Idea Lab

We have a file and upload the data in FAW through a dataset. Faw automatically sorts the data when creating a workbook

3
3 votes

Declined · Last Updated

Comments

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    What is the goal here? Sort order is often defined at query time. What do you hope to know or do based on "uploaded" sort order?

  • Joshua Co
    Joshua Co Rank 2 - Community Beginner

    Hello, we need to be able to download the data based on how it was uploaded. The order of which it was downloaded is sensitive for our vendor reports. Using a VLOOKUP can cause errors when extracting the data.

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    The purpose of upload is to use the data in FAW/OAC and the purpose of download is to able to export data from the system. There is no VLOOKUP in OAC -- however you can create joins or blend data between files or tables. FAW and OAC are not file storage system. I would recommend you use another tool such as Oracle Content Management or similar 3rd party product for file storage.