Remove all rows if one of them contain specific number

Hey guys :slight_smile:
I have column which contain number like 0,0,0,1,0,0 and if column contain 1 remove all rows in table

1 Like

Hi @pjacob, have you tried the row filter node?

1 Like

Hi @pjacob,

you could do it with Moving Aggregation Node
Sum over all rows, as new Filter column

Then use the row filter with include only 0 this column.

With this the whole table will by empty if at least one row exists with an value >1 :slight_smile:
In case you want to filter for an exact value or string you can use the rule engine beforehand to create the required input structure :+1:

1 Like

Hi @pjacob

I have a doubt about the content of your column. If every value β€œlike 0,0,0,1,0,0” is in a different row, a possible solution is here below:

Hope this is of help.

Best regards

Ael

2 Likes

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