This is the second tutorial on filtering. As discussed in the previous tutorial, we have a plain file and want to know what kind of information is present in it. In the previous section, we listed and counted the words in the file. Now, we will apply some extra filters in order to refine our work.
Open the transformation from the previous section.
Add a Calculator step, link it to the last step, and calculate the new field
len_word
representing the length of the words. To do this use the calculator function Return the length of a string A. As Field A type or selectword
, and as Type select Integer.Expand the Flow category and drag another Filter rows step to the canvas.
Link it to the Calculator step and edit it.
Click on the <field> textbox and select counter.
Click on the = sign, and select >.
Click on the <value> textbox. A small window appears.
In the Value textbox of the little window type
2
.Click on OK.
Position...