How to update the one table data into another table.

hemanth40
Tera Contributor

i have pulled the asset data from Intune system to ServiceNow into one table ( intunedata) by using the intune spoke

 

now i want to load the data from intunedata table to alm_hardware table with transform map. 

 

Please let me know how can we do that , how to run the import set and load the data by using the  transform map

2 REPLIES 2

Appli
Mega Sage
Mega Sage

Hi, you may consider using a script (example here) or export one table to XML and import it back to another table over XML import set with transform map.

Hope it helps

SwarnadeepNandy
Mega Sage

Hello @hemanth40,

 

There are a few possible steps to load data from one table to another with transform map in ServiceNow. One step is to create an import set table that matches the structure and fields of the source table (intunedata). You can do this by navigating to System Import Sets > Create Import Set Table and selecting the Copy from existing table option. Then, you can choose the intunedata table as the source and give a name to the import set table.

Another step is to create a transform map that defines the mapping between the source table (intunedata) and the target table (alm_hardware). You can do this by navigating to System Import Sets > Transform Maps and clicking the New button. Then, you can give a name to the transform map, select the source and target tables, and configure t...

A third step is to run the import set that loads the data from the source table (intunedata) to the import set table and then transforms it to the target table (alm_hardware). You can do this by navigating to System Import Sets > Load Data and selecting the import set table that you created. Then, you can click the Import All Records button and wait for the import to complete. You can check the status and results of the import by clicking the View Import Set Runs link.

 

Hope this helps.

 

Kind Regards,

Swarnadeep Nandy