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