topic tMap - no output even if expression is correct in Talend Studio

tMap - no output even if expression is correct

Anonymous — Sat, 16 Nov 2024 04:26:50 GMT

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

Re: tMap - no output even if expression is correct

Anonymous — Tue, 08 Oct 2019 04:59:59 GMT

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

Re: tMap - no output even if expression is correct

TRF — Tue, 08 Oct 2019 06:00:41 GMT

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

Re: tMap - no output even if expression is correct

Anonymous — Tue, 08 Oct 2019 07:22:12 GMT

Perfect! it works