tMap not recognising value - please help!

JM39 — Sat, 16 Nov 2024 01:29:44 GMT

Hello all. I desparately need help with this issue as it's driving me mad!

In my tMap I have this

row5.Code.equals("GB") ?

row2.Postal_Code :

row2.State

To get the row5.Code I'm using a csv lookup which uses the state field in the input file to derive the country code. And it correctly derives it. My input file is also csv. So for a name field I want to use the postcode if the country is GB, else use the state field. But it doesn't seem to recognise any of the derived GB values & puts the state in the name for every one of them.

I've attached some screenshots of my job and tMap. Thanks in advance!

Re: tMap not recognising value - please help!

manodwhb — Thu, 10 Sep 2020 14:20:18 GMT

@JulieM39 JulieM39 , the below expression will work.

row5.Code.equals("GB") ?

row2.Postal_Code :

row2.State

but you can write this to avoid null pointer exception by writing the below way.

("GB").Code.equals(row5.Code) ?

row2.Postal_Code :

row2.State

with the above expression if your not getting expected result may be the joining fields from row5 to row2 is not matching. you need to check the join criteria and data what you are getting.

Thanks,

Manohar

topic Re: tMap not recognising value - please help! in Talend Studio

tMap not recognising value - please help!

Re: tMap not recognising value - please help!