topic Compare 2 numbers or values in Talend Studio

Compare 2 numbers or values

lmit — Tue, 08 Nov 2022 08:22:30 GMT

Hi all,

I have a small requirement where I need to compare 2 numbers and get the results, let’s say my input is like below

col1;col2

1;2

2;2

3;2

my output should be like

cok1;col2;results

1;2;1

2;2;0

3:2;-1

if 2 numbers are same it should return 0 , greater -1 and lesser +1

i tried using methods like greater or greaterorequal but not getting the exact results

can anyone suggest other methods

thanks,

lmit

Anonymous — Wed, 09 Nov 2022 03:27:00 GMT

Add a new column in the output table on tMap, and set its expression like this:

row1.col1==row1.col2?0:(row1.col1>row1.col2?-1:1)

Regards

Shong

lmit — Tue, 15 Nov 2022 08:41:41 GMT

Thanks @Shicong Hong ,