How to use the single transform map to load multiple sheets of data from Excel sheets into the staging table.

[prasad_rachapud]

We have a requirement to export multiple sheets of excel data using a single transform map. The transform map should load all of the data from different sheets.

I've added an attachment for reference. In this excel sheet we have 3 sheets. All 3 sheets of data should load at the same time.

[Anmol8]

Hello dear,

You just had to create a single staging table or you can say import set table . I can see the fields are of sys_user table so just give different sheet no while uploading the file, and use same import set table. 

You can later select manually mapping assist and create same transform map. Then your data will be loaded.

Also use coalsce if you need to update a field with other data.

Refer the Screen shot.

Thanks

Please mark Helpful.

Regards 

Anmol 

[Ankur Bawiskar]

Hi,

you can have single transform map but it will map to only 1 target table and you can use scripting

if your excel contains data for other tables then you need to create multiple transform map

Regards
Ankur

[Jeffrey Siegel]

How do you tell it to grab each tab? i have two tabs, due to excel tab limitations my data is split between them, i want to grab it all in one import job and then transform both tabs data at one time.

[Sharique Azim]

Same question. And it wont load both sheets together