Transform Map

[Vaishali 11]

I have an excel data with site code and did field. Each site code is aligned to few did numbers. I want this data to load into the ServiceNow table.

How can I achieve this?

[SatyakiBose · Accepted solution]

Hello @Vaishali 11 

The steps are:

1. Navigate to system import sets -- > load data
2. Load the excel sheet
3. Once the data is loaded, you would get the Create transform map option (this would come up if there is no existing transform map present in the instance)
4. Here you can select the target table, and then map the columns in the excel sheet to the fields on the target table.
5. Once the mapping done, you need to click on transform now.

You can read more about the process here - https://docs.servicenow.com/en-US/bundle/tokyo-platform-administration/page/script/server-scripting/...

[SatyakiBose · Accepted solution]

Hello @Vaishali 11 

The steps are:

1. Navigate to system import sets -- > load data
2. Load the excel sheet
3. Once the data is loaded, you would get the Create transform map option (this would come up if there is no existing transform map present in the instance)
4. Here you can select the target table, and then map the columns in the excel sheet to the fields on the target table.
5. Once the mapping done, you need to click on transform now.

You can read more about the process here - https://docs.servicenow.com/en-US/bundle/tokyo-platform-administration/page/script/server-scripting/...

[Namrata Ghorpad · Accepted solution]

Hello,

Search Load Data in application navigator and then select the import set table name or create new table and select the excel file. After loading the data create transform map and select target table where you want to insert records. Click on the link Mapping Assist and then select the fields from source and target table and save the form and Click on run Transform.

Check the below link.

https://www.servicenow.com/community/developer-forum/how-to-load-data-to-table-from-excel/m-p/145186...

Please mark my answer as helpful/correct if it helps you.

Regards,

Namrata