Conditional Filter

Hi there @Auzzie99,

welcome to Community!

You are right. Rule-based Row Filter node is one for filtering based on one or more conditions but not sure you can use it in this case. Your column has leading zeroes so I guess it is string type and greater operator won’t give you right results on string column. On the other side if you convert it to number then you will lose leading zeroes. To overcome this I would use Column Expressions node which uses JavaScript syntax and automatically converts string to number when using greater operator. This line should do the trick:

column("column1") > 10 || column("column1").startsWith("00")

This will return Boolean true or false value in new column and then use Row Filter or Nominal Value Row Filter or above mentioned Rule-based Row Filter node to have wanted rows.

Considering you are coming from Alteryx check this topic:

In it, among other things that can help, you will find link to new book From KNIME to Alteryx :wink:

Happy KNIMEing!

Br,
Ivan

1 Like