How to map data between two tables

[Sandeep Rajput]

@Shruti07 You can use transform map to map data between an import set table and a target table for more information please refer to https://docs.servicenow.com/bundle/xanadu-integrate-applications/page/script/server-scripting/concep...

Please mark my response helpful and accepted solution if it addresses your question.

[Dr Atul G- LNG]

Hi @Shruti07 

Do you want to bring the data in SN ? then use transform Map.

https://youtu.be/q4sYQb77WKY

[Ravi Gaurav]

HI @Shruti07 ,

If you are just mapping the data from the "import Set " table to target table go with Transform map.
If you to merge the data from 2 tables and wanted to create a report then go with 'database view'.

--> video 
https://www.youtube.com/watch?v=CJMHSyeNAAQ&pp=ygUdU2VydmljZW5vdyByYXZpIHRyYW5zZm9ybSBtYXA%3D

[Sai_Charan_K]

Hi @Shruti07 ,

Mapping data between 2 tables can be done in many ways. 
1) We can use transform maps to map data between 2 tables

2) We can use database view to collate already existing data between 2 tables.

It would be easier if you could elaborate on what exactly you are looking for. 

Please mark my response "helpful" and "accepted solution" if it has addressed your question.

Thanks and Regards, 
K. Sai Charan
Sr. ServiceNow Developer
Deloitte India

[AndersBGS]

Hi @Shruti07 ,

Please provide some additional information. What are you trying to do? what is the business need etc. etc., as your post doesn't make much sense. 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders