Run Multiple Transform Maps off one Import Table

Fraggle Rock
Tera Expert

‎11-27-2023 02:56 PM - edited ‎11-27-2023 02:58 PM

hi  there i  have some data coming an external source that i have set up a import set to for but based off the value of one column i want a import the data in to different tables in the CMDB. some will go to  the services table (cmdb_ci_service) the rest going into the software table (cmdb_ci_spkg)  

 

i am try to find if this can be done with a single import set, two transformation maps and some kind script (that i dont know how to write) or if it just easier to split in to two imports

 

this import file is not large about 100 to 150 lines and would only be run monthly 

 

0 Helpfuls
  • 1,080 Views
1 REPLY 1

Sandeep132
Kilo Sage

‎11-27-2023 05:06 PM

Hi Fraggle,

 

You can use the single import set and create 2 transform maps targeting the tables you are looking for. On each transform map you can write on before transform script to validate the field value and ignore the row transform if they don’t match the conditions you are looking for. You can find more about the transform scripts here https://developer.servicenow.com/dev.do#!/learn/learning-plans/utah/new_to_servicenow/app_store_lear...

 

hope this helps.