Row filter

[ycbing77]

I want to get data from AA to CC, AA always in 3rd row, and CC next row always is Total, row count which from AA to CC is variable, not fixed, some time is row count =3,4,5.etc.

[HansS]

Hi @ycbing77

I was thinking of something like this
row_filter.knwf (26.6 KB)

gr. Hans

[takbb]

If you have KNIME 5.1, and the column values to find have specific values, such as “aa” and “cc”, you can also use the new Table Splitter node…

First table splitter:

Second table splitter:

It would be even better in my view if the search “pattern” allowed us to specify wildcards or regex here, but even so it still looks like a useful node. If you do need regex/wildcards, then using those in the solution from @HansS is the way forward