It is quite common to have a need to filter out rows in a file. For example, the Excel worksheet below has 4 lines which can be considered headers, but only the first one is an actual header.
It would be great if there was a way to filter out some of the rows in a file.
Step 2. Use filter transformation to filter out rows in a file.
For the example above the filter would need to be set to:
row == 0 || row > 3