Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to choose how the Multi-sheet excel data interpreted when imported
It is curretly possibly to import an excel file with multi-sheets however all the sheets are interpreted and model as a data mart model and the relevant joins are also suggested. However in one of my customer site it is the similar data provided by different team but it came as multiple sheets in the excel. It would be great if as a developer there is an ability to choose if the data in multiple sheets should be treated as single table (all sheets - 1 table) or multi-table (1-2-1 sheet to table).
Comments
-
Hi - Thank you for submitting this idea, I believe the new option would be to do the equivalent of a union of multiple sheets in the Excel into a single "Table" in the dataset. This is something that we have been exploring as a candidate for the roadmap, but community votes will help us to prioritize the feature. QQ - is the case where either all the sheets have different data and can be treated as separate tables or ALL the sheets in the spreadsheet contain the same data and can be combined into a single table - or will there be a mix? — this would be important to understand examples since the latter would require a bit more interaction and input from users.
1 -
@Luis E. Rivas -Oracle Let me add my usecase as well.
- Majority of times , data will be different for each sheet.
- Few cases we need to union two sheets into one table.
1 -
Thanks for the comments and expanding the details. Yes, that's correct treating the data from multiple sheet data into a single table as union dataset.
To keep it simple, my thoughts are that the multisheet excel is either a single table dataset that needs to be union and loaded in single table or the multisheet excel contains data for a datamodel.
However looking at @Rajakumar Burra comments if possible having the facility of selecting which sheets to be union as single dataset and others can become part of standard model as fact-dimension. I beleive the multisheet import is already delivered recently.
0 -
@Rajakumar Burra please do vote as Luis alreday suggeted to get more votes.
0 -
@mgoswami @Rajakumar Burra - thanks for the additional details.
1
