Dynamic Filter

Hi, I have table where I would like to detect a pattern in a cell and then filter out all of the rows above that cell.

In the example table below I want to use regex to find the pattern ‘B’ in the ‘Label’ column. I was then hoping to use the rowID node to store that location and then use that value as a flow variable to filter rows above or below that value. Is this possible?

Example Table:
Label Value
A 2
B 3
C 8

Hi @pcouture03,

first of all: Welcome to the KNIME Community!

Your proposal is pretty close to the solution I found. See the attached workflow.

Kind regards,
agaunt

Dynamic Filter.knwf (15.7 KB)

3 Likes

This is perfect, thanks!

2 Likes