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

Directly Edit Dataset Data within OAC

Needs Votes
23
Views
1
Comments
User_FBG8L
User_FBG8L Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server Idea Lab

We want to edit Dataset data direclty in OAC.

We have manual files we upload & this is treated as static data. However there are times when we want to manually add a column or edit a cell value. If its editing a cell values or column name, some users will need to open the dataset in OAC, export as Excel file, edit file then reupload.

If its a new column, we perform the same steps above except instead of reuploading to the existing dataset, they have to delete the dataset & upload the file as a new dataset because reuploading file does not allow extra columns.

2
Up
2 votes

Needs Votes · Last Updated

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    The dataset editor allows you to add and rename columns. Analytics tools are not generally tools for modifying individual rows, but some facilities allow you to do that in bulk within OAC.

    e.g. I can fix a misspelled Sidney to Sydney, but it will fix all rows with that error. I can also use the grouping tool to bulk rename values. However, I cannot easily change Sydney to Melbourne for one specific row.