New column, if, then, filter?

[Markus3003]

Hi all,

I’m quit new to knime and would need some help. Please check my screenshot:

I have an existing column E “Code”
I would like to put in the Column F “Account” the following rules:

If E = “L77” then put 667901
if E = “B*” then put 603000
and in the other cases put 64733.

Any ideas how to realize that best?

Thank you in advance.

BR
Markus

[bruno29a]

Hi @Markus3003 , this can be done with a Rule Engine node as follows:

And the rules you would use are:

$Code$ = "L77" => 667901
$Code$ LIKE "B*" => 603000
TRUE => 64733

$Code$ is basically your column name “Code”
$Code$ = "L77" => 667901 means if value of column Code = “L77” then return 667901
$Code$ LIKE "B*" => 603000 means if value of column Code starts with a “B” then return 603000
TRUE => 64733 means if none of the above conditions applied, return 64733, which basically means it’s the default value.

And since I use the option “Append Column” with column name “Account”, it will create a new column Account and add the returned values to it.

Results:

Here’s the workflow: New column if then filter.knwf (6.7 KB)