Use cases on transform map scripts

[abhishekmittal]

Hi,

I am new to servicenow and trying to learning each of modules of SNOW.

Can anyone help me to provide the use cases on transform map scripts?

Thanks and Regards,

Abhishek

[Shishir Srivast]

Please check: Transform Map Scripts - ServiceNow Wiki

you can also check OOB transform map under this sys_transform_map_list.do table.

[Srvs]

Hi Abhishek,

Please check: Transform Map Scripts - ServiceNow Wiki

and also the out of the box transform map on this sys_transform_map_list.do table.

i think this will helps you,

please click on your question and mark the thread as answered and helpful,

if you have anything ask me.

[antin_s]

Hi Abhishek,

You may use Transform Map in the following Use Cases.

1. You have an Excel/CSV files and want to import that data into ServiceNow Tables. You will first insert the data into Import Set Table (temp tables). Transform Map will help you to map the field between the Import Set Table and the Business   Table.

2. From an external system you want to send some data to ServiceNow, but you want to do some processing before inserting the data into business tables. You will invoke the Import Set APIs to insert the data into Import Set tables, and then use Transform Map to move the data to Business Table.

Basically, Transform Map helps you to move data from Import Set tables to Business tables using Field Mapping and scripts.

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin

[Srvs]

Hi Abhishek,

at the time of loading the bulk user into snow users table we will use

1)import set and

2)transform map

1) import set is used to get the data from other sources like excel sheet and csv file

2) transform map is used to match the columns from import set to snow base tables. to load the data into snow base tables.