Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Importing Data from Multiple Sheets in an Excel File into Multiple Database Tables

Hari S1
Tera Contributor

‎12-05-2024 10:14 PM

Hi,

 

In an Excel file, we have three sheets: Sheet1 contains user-related data, Sheet2 contains group-related data, and Sheet3 contains Windows server-related data. If we want to import the data from these three sheets into three different tables at the same time, how can we do that?

 

 

Thank you

0 Helpfuls
  • 504 Views
1 REPLY 1

Sanjay191
Tera Sage
Tera Sage

‎12-06-2024 12:15 AM

Hello @Hari S1 

You could use the sheet number to get the record of particular  sheet like sheet 1, sheet 2 and sheet 3 and need to Create Data Source for the three  different sheet and run the transform map accordingly . And also You can use the Robust Transfer for this to load data for the more then one table .

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thank You