Column comparison

[Brain]

Hi,
From this example, I want to create a column V. In this column, if the value in column S3 is the same in column 400F, then it should say YES; if it’s different, then NO.
I’m not getting the correct result using 'EXPRESSIONS with KAI
Thanks
Br
HK Results25 (4) - Copie.xlsx (9.0 KB)

[MartinDDDD]

Hey there,

I gave it a try and I think it worked with both column expressions and expression nodes

Expression:

Formula:

if($["S3"] = $["400F"],"YES", "NO")

Column Expression:

Formula:

if(column("S3") == column("400F")) {
    "YES"
} else {
    "NO"
}

Workflow:

compareCols.knwf (83.8 KB)

Can you share the workflow where it is not working?

[Brain]

Thanks for your quick answer but it is very strange. Using your expression if i continue my workflow i dont get the good result :

If i stop my worklow at this point use excel Writer start a new Workflow the result is correct !

[MartinDDDD]

Hmm. Have a feeling that this might have something to do with floating point precision - just looking at the “-0” in the diff column…

Can you try and round the values to two decimals before the Expression ( column Expression node) using e.g.

Number Rounder

[Brain]

OK
If i round 2 decimals i get 4 bad answers with dif 0,01. With 1 decimal it’s ok. I will deal with that.
Thanks
Br