Query on Rule based row filter

[balajiknime]

Hi, please refer the below sample table. I need to filterout GL account 65240093 with an exception of rows with Profit center A400.

Would you please help me on how to set this filter on Knime. I am trying with “Rule based row filter” node. I could able to filter out the GL but not able to set the exception part of the instructions.

=|Department | GL Account | Profit Center |
|Electric | 65240010 | A444 | |
|Refinery | 65240093 | A300 | |
|Admin | 65240093 | A400 | |
|Admin | 65240093 | A455 | |
|R&D | 51228005 | A455 | |

[HansS]

Hi @balajiknime

Try this

$GL Account$ = 65240093 AND NOT $Profit Center$ = “A400” => TRUE

gr. Hans

[balajiknime]

It worked !!!

Thank you very much!!!

Appreciate you quick response !!!

[HansS]

Hi @balajiknime

Tnx for validating. Can you mark this post as solved .

gr. Hans