I have a csv file with two lines (Line #1 is the header and line #2 has the actual data). How do I exclude or skip the header line in the iterator node?
I want to skip line #1 and start parsing at line #2
Thanks
One of the output variables of the Data Iterator node is the NODENAME_recordNumber, for example DataIterator8550_recordNumber.
The iteration number, starting with 1. When the activity is finished iterating, this will contain the number of records returned.
For the header, the recordNumber will be 1.
DataIterator8550_recordNumber == 1
Create a line counter variable initialized to 0 (zero). Get the first line from the iterator and increment the variable. If this evaluates to 1, then skip to the end of the iterator so it will go to the next line. If the variable is greater than 1, then process the data as required by the flow.
ok thank you - will take a look
Thank you - That is a cleaner way
