Removing rows which contains "true", across multiple columns

Hi all,

I have used column expressions to filter if certain values occur within different columns which works fine. (for e.g.

However, I now have three output columns (“PartResult”, “JobResult” and “TopResult”, which either contains true or false.

I want to remove the rows which contain true in all of them.

I know I can use the row filter or splitter, however I can only perform this on one column so I would have to use three of those nodes in a row.

I am wondering if there is a way to do this within one node?
I was thinking of using the Column expressions, however I am not sure what syntax to use to achieve this.

Any guidance on this would be helpful, thanks!

This node will allow you to use multiple conditions across multiple columns as a filter test.

4 Likes

Just to add,
If you have boolean values I would go with column aggregator node and then use minimum
If the result is true it only contains true values across all the rows

save

Then do a row filter
Advantage: It does not matter if you have 3 or 300 columns
br

2 Likes

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