In the Etlworks Integrator, you can filter rows in a flat file through two simple steps.
It is common to need to filter out rows in a file. For example, the Excel worksheet below has four lines that can be considered headers, but only the first is an actual header. There is a way to filter out some of the rows in a file.
Here are the steps to do this:
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