Process excel with multiple sheets on 1 table using single transform map

mballinger
Mega Guru

‎03-14-2024 03:31 AM

Hello,

 

we have a requirement for data correction. The excel provided has 4 sheets. All sheet have the same column names, but the sheets have different titles. How can I load 1 excel document and process all 4 sheets in one load to a single staging table? These records will get mapped to the same target table. There are some transform scripts that we will need to apply as well.

 

thanks! 

0 Helpfuls
  • 1,115 Views
2 REPLIES 2

Ranjit Nimbalka
Mega Sage

‎03-14-2024 03:39 AM - edited ‎03-14-2024 03:40 AM

Hi @mballinger ,

 

you have to load file multiple time just change the sheet number while uploading the file.

 

 

Regards,

Ranjit

0 Helpfuls