How to transfer data from staging table to multiple CI class tables?

[Nilofer]

I have a transform map as shown below

The data from the staging table has to be moved to various other tables in cmdb_ci. 

For example, if the field value of "resource type" in staging table is 'Linux' then the data should be moved to dedicated linux table.

How is this possible? Kindly assist me with it. 

[piyushsain · Accepted solution]

Hi @Nilofer  

You can create multiple Transform maps to a single data source, in each Transform map you can script to ignore any row that is not needed for that target table  

[Dr Atul G- LNG]

Hi @Nilofer  

Give a try on below link

https://www.servicenow.com/community/now-platform-forum/transforming-data-on-the-cmdb-tables-and-set...

[piyushsain · Accepted solution]

Hi @Nilofer  

You can create multiple Transform maps to a single data source, in each Transform map you can script to ignore any row that is not needed for that target table  

[Nilofer]

Could you provide me a sample script for reference?

[piyushsain · Accepted solution]

for example if you are in Linux Transform Map:

if(source.resource_type == 'Windows')

ignore= 'true'

else if(source.resource_type == 'Linux')

write_your_logic