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

[mballinger]

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! 

[Dr Atul G- LNG]

Hi @mballinger 

https://www.servicenow.com/community/itsm-forum/how-to-use-the-single-transform-map-to-load-multiple...

https://www.servicenow.com/community/now-platform-forum/how-to-to-import-data-from-an-excel-sheet-ha...

[Ranjit Nimbalka]

Hi @mballinger ,

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

Regards,

Ranjit