IF STATEMENT

[ayesha_target]

Can someone help me with above code how do i write in KNIME with col exp node ?

[ArjenEX]

Hi @ayesha_target,

This is quite confusing. Can you post your current input in a table form and the expected output?

Is the rule you’re looking for that the age column should be updated to a value of 365 if the conditions are all met?

[ayesha_target]

so in my raw data age col is blank i am trying to figure out that if my age band is over 360 and other conditions are met then can over write the age col by putting the 365

[ayesha_target]

i would need to write for all age bands

[ArjenEX]

You can use a Rule Engine node for this. Below is a small example that you can use as starting point to build up all the rules. You can just add more AND statements if more fields need to be evaluated.

$Age Band$  = "Over 360 Days" AND $Source$ = "GMRS" => 365
$Age Band$  = "0-7 Days" AND $Source$ = "GMRS" => 5
$Age Band$  = "181-360" AND $Source$ = "GMRS" => 186

[ayesha_target]

Hello ArjenEX, thanks for help on previously How can i do using col exp? below is my flow and data sample

[ayesha_target]

I already have Rule engine in the flow see below one of them if i use another rule where do i have to add this node ?