Overview
In Etlworks, you can filter rows in a flat file such as CSV or Excel.
Example
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.
Process
Here are the steps to do this:
Step 1. Create an ETL Flow where the source is 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
Comments
0 comments
Please sign in to leave a comment.