We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Transform Map with potentially multiple sources per line

Travis Michigan
Mega Sage

I'm looking for some direction on something I'm having a little problem sorting out.  

 

I am trying to make a transform map for a particular data source.  The data source is a CSV file that contains a row for each Firewall Security Policy.  In that row it also contains a column for the source/destination network.  Those networks may be one line, or 10 on that row.  

 

So is it possible to create a transform map look at the number of lines, in that row/column and create an entry for each one?  Here is an example of one row with fake data and this one has 2 Source Networks in this example in case I am not describing it well:

TravisMichigan_0-1712332985900.png

 

1 REPLY 1

chaithu1489
Kilo Sage

use the transform script and load the data. I don't know about any OOB solutions for this.

Else spend time to clean the CSV and import the data