Let's start by developing the first part of the transformation. We will read the file and filter the data. In this case, the solution is quite straightforward (this will not always be the case). There is a PDI step for each of the tasks to accomplish. The CSV file input step will serve for reading the file, and the Filter rows step will filter the rows. The instructions are as follows:
- First, create a transformation. You can do this from the main menu, from the main toolbar, or by pressing Ctrl + T.
- From the Input folder that contains steps, drag and drop a CSV file input step to the work area.
- Double-click on the step. A configuration window will show up.
- Click on the Browse... button to locate ...
