Multiple row filter

Hi,

I would like to do  multiple row filters. For eg consider table below as input table. I want to filter out all rows with value 0 in columns C%, P% and SI% with the help of a single node.

MATERIAL C% P% SI%
A 2 4 0
B 0 1 4
C 3 0 2
D 6 9 6

Output

MATERIAL C% P% SI%
D 6 9 6

Thanks

Use the Rule-based Row Filter and define your own rules, e.g.

$C%$ = 0 OR $P%$ = 0 OR $SI%$ = 0 => FALSE
TRUE => TRUE

Hope that helps,

Jan

 

Yes. Thanks Jan