- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2025 04:18 AM
Hi,
I tried to implement below requirement but unable to find the solution. can someone help me
"Suppose I have an Excel sheet where there are 10 columns of data. First five columns belong to the Hardware table and the last five columns belong to the Software table. I want to map these data into ServiceNow (Hardware & Software tables) in a single upload?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2025 04:24 AM
Hi @HarikrishH ,
if software and hardware are child of any table you can simply use sys_class_name and set the table name
else
you can create 2 transform maps 1 for software table and 1 for hardware table with single import both will run and move the data to the respective tables
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2025 07:10 AM
Hi @Chaitanya ILCR ,
Rajesh Chopade's solution worked for me. However, I would like to know how I can create two transform maps for a single import set table. Could you please share screenshots of the transform maps and where they should be created?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2025 07:39 AM
Hi @HarikrishH ,
keep the source table as same and change the target table
example source table is imp_user and target is table1 and table2
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2025 04:27 AM
as Chaitanya mentioned, you need two transform maps