How to update the one table data into another table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 02:52 AM
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
- Labels:
-
Asset Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 03:21 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 03:23 AM
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