Oracle Communities

Oracle Analytics and AI

Child Item

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).

Find more posts tagged with

Data Modelling and Datasets

Data Preparation and Flows

FDI

OAS

Needs Votes

oacs

Status: Needs Votes

Comments

Luis E. Rivas -Oracle

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.

Rajakumar Burra

@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.

mgoswami

Hi @Luis E. Rivas -Oracle,

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.

mgoswami

https://community.oracle.com/products/oracleanalytics/discussion/comment/62784#Comment_62784

@Rajakumar Burra please do vote as Luis alreday suggeted to get more votes.

Luis E. Rivas -Oracle

@mgoswami @Rajakumar Burra - thanks for the additional details.