Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

luffy3478
Tera Guru

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