Transform Map with potentially multiple sources per line
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2024 09:03 AM
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-06-2024 01:35 AM
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