I have column which contain number like 0,0,0,1,0,0 and if column contain 1 remove all rows in table
Hi @pjacob, have you tried the row filter node?
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
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.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.