Import data into multiple tables via Data source/Transform map

[Dinesh90]

hello Developers,

This is related to one of the requirement to import the data into multiple tables 🙂

I have the excel in which I am having 9 fields with the data  but these 9 fields data does not belongs to one table , these belongs to 3 different tables.

so basically I need to import the data into the data into 3 different target tables.

Here is a challenge these 3 targets tables are inter-linked to each other means they have the parent - child relationship.

Target tables are

1). Contract->Expense Line

2). Contract -> Users covered

expense line have a reference field for contract record

User covered record also have a reference for contract record.

My challenenge here is - while importing the data which needs to be imported in 3 target tables..

how should I set the relationship between them..

Firstly contract record will be created then expense line and then contract and user linkage to done..

Please help with the approach to link the target records while importing.

Thanks !

[sourav1999]

-Data sources can be used to import data into multiple tables in ServiceNow
-Data sources can be used to transform data from one format to another
-A Transform Map is used to define the data transformation from one format to another
-The Data source and Transform Map are configured together to import data into multiple tables in ServiceNow

For asking ServiceNow-related questions try this :

For a better and more optimistic result, please visit this website. It uses a Chat Generative Pre-Trained Transformer ( GPT ) technology for solving ServiceNow-related issues.

Link - https://nowgpt.ai/

For the ServiceNow Certified System Administrator exams try this :

https://www.udemy.com/course/servicenow-csa-admin-certification-exam-2023/?couponCode=NOW-DEVELOPER

[latroyamitchell]

You only defined the process.  Didn't really target the issue...

[nabilelakhdar]

You should create 3 transform maps one for every table. The first one should be Contract ( you can change the order field in the transform map)  since it is a reference filed in the two other tables.

[Angelo Cortesi]

You can easily solve it by using RTE instead of Transform Maps.