Filter Data

Hi all,

is there an eaysier way to do that?

E.g. can I use one node and put there all the numbers I want to filter?

image

Thank you and BR
Markus

Hi @Markus3003 , most definitely yes, it can be done in 1 Row Filter node.

You can use this expression:
38610000|38611000|38610900

This expression basically reads as: “38610000” or “38611000” or “38610900”

Input data:
image

Result:
image

EDIT: Some additional notes:
For more complex rules (especially if you need to apply rules involving multiple columns at the same time), you can also use the Rule-based Row Filter node, which you can use also in this case. There are a few ways to write the same rule (hence the flexibility):
1:

$column1$ = "38610000" => TRUE
$column1$ = "38611000" => TRUE
$column1$ = "38610900" => TRUE

2:
$column1$ = "38610000" OR $column1$ = "38611000" OR $column1$ = "38610900" => TRUE

3:
$column1$ IN ("38610000", "38611000", "38610900") => TRUE

4: (This would be the literally translated version of what I suggested for Row Filter):
$column1$ MATCHES "38610000|38611000|38610900" => TRUE

4 Likes

Look at Rule-based Row Filter — NodePit

The Row Filter (Labs) Node would also work.

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