Import data from multiple tabs/sheets in Excel

[MukeshP203]

I have a requirement where i have a catalog item with excel template and upload button. Now the excel has two sheets, in one sheet there is data of a certain table and the other sheet contains data of other table (like reading, fuel) but both are related. I have to transform this data into specific tables.

[Dr Atul G- LNG]

Hi @MukeshP203 

You can use the same source, but you need to create two different transform maps to link with two different tables

[Ankur Bawiskar]

@MukeshP203 

then you can have 1 data source, 1 transform map on any table (reading or fuel)

1) Don't use field maps

2) you can use single transform map on any target table either A or B and handle everything in onBefore transform script

what did you start and where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MukeshP203]

My mistake, reading or fuel are fields from the 2nd table. Also , with 1 data source how will the 2nd sheet's data will be extracted?

[sravanikinfy]

How do we automate this instead of loading manually through transform maps.