math formula

hi

how can i create new column whith math formula node whith special condition

for example if a record in column A is alive set in new column 1 otherwise 0

i mean what is the Expression code in math formula node for this target?

thanks

Hi,

 

It depends on your data type (Double, Integer, String, etc.).

Could it possibly be done with the "Rule Engine" node ?

 

Kind regards,

Baptiste

hi my data type is integer

i want if that is 1 then new column have value:yes

else 

no

thanks

 

Hi Hossein,

You can use the "Engine Rule" node, as Baptiste suggested you.

You can use 2 rules like the following (in this order):

$your_variable$ = 1 => "YES"
TRUE => "NO"

Is this working in your case?

Cheers,

Gio

hi dear gcincilla

yes it is working

thanks a lot