Tranform maps

HarikrishH
Tera Contributor

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?

Chaitanya ILCR
Giga Patron

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

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!

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

ChaitanyaILCR_0-1748615689453.pngChaitanyaILCR_1-1748615693805.png

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

 

Hristo Ivanov
Kilo Sage

as Chaitanya mentioned, you need two transform maps