Chapter 9. Setting Up the ExtFilter Component

Double-click ExtFilter, click the Filter expression attribute row in the component editor and you will see the following Filter Editor:

Figure 9.1. Filter Editor

Now select the salary item and double-click it. The $0.salary expression will appear on the blue background in the pane at the bottom.

Figure 9.2. Selecting a Field

Click on the right side from the $0.salary expression. The blue background will disappear.

Figure 9.3. Field Selected

Select a "greater" sign by clicking. It will appear in the pane on the right side from $0.salary.

Note that CloverETL validates the expressions automatically. Now an error will be found.

Figure 9.4. Selecting a "Greater" Sign

You need to complete the expression so that it becomes valid. Click at the right from the expression. Then type 24000. After typing the number, the expression becomes valid again.

The number is the salary that will serve to filter incoming data flow. Only data records with salary higher than 24000 will be sent out.

Figure 9.5. Filter Expression Defined

By clicking OK, you close the FilterExpression editor.

When you click OK, you can see that the warning icon has disappeared from the ExtFilter component:

Figure 9.6. Warning Icon Has Disappeared

Now continue with ExtSort.