Filter a row when condition is meet in a cell

[wuzgood]

Hi there,

I have a table with a multiple columns column where I have different values MATCH and NOT MATCH.

And I want to list all the rows that have NOT MATCH value

example:

from here:
Test 1 MATCH - MATCH - MATCH - NOT MATCH - MATCH
Test 2 MATCH - MATCH - MATCH - NOT MATCH - MATCH
Test 3 MATCH - MATCH - MATCH - MATCH - MATCH
Test 4 NOT MATCH - MATCH - MATCH - NOT MATCH - MATCH

to here:
Test 1 MATCH - MATCH - MATCH - NOT MATCH - MATCH
Test 2 MATCH - MATCH - MATCH - NOT MATCH - MATCH
Test 4 NOT MATCH - MATCH - MATCH - NOT MATCH - MATCH

Thank you for your help!

[elsamuel]

Hi @wuzgood, welcome to the forum.

I’d start with trying a Rule-Based Row Filter using the rule:
($column1$ = "NOT MATCH") OR ($column2$ = "NOT MATCH") OR ($column3$ = "NOT MATCH") OR ($column4$ = "NOT MATCH") OR ($column5$ = "NOT MATCH") OR ($column6$ = "NOT MATCH") => TRUE

Starting table:

Result:

[wuzgood]

Thank you! I use this for now will try to improve it since I have a lot of columns.

[Omprakash_Jena]

@wuzgood

rows that have

Hi @wuzgood , try using loop. Reply back for any questions.

[Daniel_Weikert]

You could aggregate your columns (use concatenate as aggregation) then do a wildcard row filter (exclude not) and then split your columns again

Input

Output

bR