Hey guys
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,
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
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 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.