Row Filter with Collection Element

Hi guys!

I saw many questions about row filter and the option “collection element”, How does it works?

Well, keep in mind that you need a column to be filter and some criteria to make this search.

So, if you have a table with a column to check/filter by some words as example, you need to create an expression to validate it.

row filter with collection element.knwf (28.0 KB)

I’ll set a dummy table with some domains names and another table with a list of domains that I want to filter as “include” from row filter node.

The first branch I’ll create a list of domains from a table. I pickup thye column and make a simple pivot from vertical to horizontal cells.

After that, I combine all columns with a separator “|”, which represent “OR” by regular expression. I set to remove all columns and let only the result.

I set this result as a flow variable, to use as pattern expression into row filter.

Now, I can select ftom a dummy table with other domains, a selection using a colletion element from a flow variable to cheche the column named as Domain.

Prints step-by-step:

image

nro 1

nro 2

nro 3

nro 4

nro 5

nro 6

As you can see above, I checked the “filter based on collection elements”, to search into “Domain” column using the flow variable that I set as “Lista”.

Now you can choose which option you need: include, exclude…

Thats It… a little trick here to understand it very well.

Tks all… BR, Denis Iongbloed

4 Likes

Nice example @denisfi! Thanks for posting it :slight_smile:

1 Like

You’re welcome! I like very much Knime and learn a lot with all community…

Seeya!

BR, Denis

2 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.