tmap expression editor

[Anonymous]

HI,
need help to form the expression in tmap expression editor.
my condition is as follows:
if (column1=10) then "ABC"
else if (column1=20) then "XYZ"
else if (column1=30) then "Def"
end if;
thank you.

[Anonymous]

Hi
Try this.

(row1.column1==10)?"ABC":((row1.column1==20)?"XYZ":((row1.column1==30)?"Def":null))

Regards,
Pedro

[Anonymous]

Hi  
i want to imlemement comulative sum in taland i m new in taland 

[Anonymous]

hi brajbhushan,
better to start a new post for new request.
nevermind, have a look at tAggregateRow :
https://help.talend.com/search/all?query=tAggregateRow&content-lang=en
regards
laurent