Need help on Number column Match or mismatch

KNIME Analytics Platform
1

Hello team, I have two Number values columns which are EMI 1 and EMI 2 , can anybody help to match this two type Number (integer) columns and give us result True or False or match or mismatch VIA COLUMN EXPRESSION, the below columns expression is not working as thronging an error

if(column(“EMI 1”)==column(“EMI 2”))
{“TRUE”}
else
{“FALSE”}

2

Hi @Madhu_Sudhan

You can also go for the Rule Engine:

$EM1$ = $EM2$ => “TRUE”
TRUE => “FALSE”

gr. Hans

2 Likes
3

Thank you sir… it helps, is there any column expression formula as my flow majorly on column expression node to validate multiple files

1 Like
4

Hello @Madhu_Sudhan
You can test the following syntax in ‘Column Expressions’ node, selecting ‘Boolean value’ or ‘String’ as output Type:

if(column("EMI 1", 0) == column("EMI 2"))
    {true}
    else 
    {false}

BR

1 Like