tMap - no output even if expression is correct

[Anonymous]

Hi, 

I have this expression which i have compiled and tested and the results is correct after testing. But when i see the output excel file, the column is empty. Any idea why?


Trade_Events.Transaction_Type_Code == "BUY"? "1":
Trade_Events.Transaction_Type_Code == "SEL"? "2":
Trade_Events.Transaction_Type_Code == "SELL_CI" ?"17":null

[Anonymous]

Hello,

Are you able to use tLogRow component instead of tfileoutputexcel component to print your result on console at the first step to see if this expression in tMap works well?

Best regards

Sabrina

[TRF · Accepted solution]

Never use == to compare strings. Change your expression like this:
"BUY".equals(Trade_Events.Transaction_Type_Code
and so on for other parts.

[Anonymous]

Perfect!  it works