topic Re: Ignore null lookup on tmap in Talend Studio

Ignore null lookup on tmap

zalibra — Thu, 19 Dec 2019 15:43:14 GMT

Trying to see if this is possible on tMap. I have data coming in from row1. Sometimes, row1.field2 has data and sometimes it's null. Is there a way when doing lookup between row 1 and row 2, I can specify "if row1.field2 is null then ignore lookup but still process row1 data into row4, else lookup row2.col5 and push row1 and row2 data into row4"?

Re: Ignore null lookup on tmap

Anonymous — Thu, 19 Dec 2019 22:30:01 GMT

Hi,

Why don't you try like below?

Relational.ISNULL( row1.field2)? null: lookup_value

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Ignore null lookup on tmap

zalibra — Mon, 23 Dec 2019 15:57:46 GMT

Gives the error "lookup_value cannot be resolved to a variable" when I used "Relational.ISNULL( row1.field2)? null: lookup_value".

Tried "row1.field2.isEmpty()?"":row1.field2" but that doesn't work either -- in this case, because row1.field2 is null, the whole record is ignored and not pushed into row4.

Re: Ignore null lookup on tmap

Anonymous — Mon, 23 Dec 2019 19:35:08 GMT

Hi,

"lookup_value" was a dummy variable I had told to give you an example. You need to provide the right varible instead from the lookup table, say row1.field2.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Ignore null lookup on tmap

zalibra — Mon, 23 Dec 2019 23:07:48 GMT

Unfortunately, still doesn't work. If row1.field2 is null, the whole record is ignored and nothing gets processed into row4.

Re: Ignore null lookup on tmap

zalibra — Mon, 06 Jan 2020 19:19:02 GMT

@nthampi any other suggestions?

Re: Ignore null lookup on tmap

Anonymous — Mon, 06 Jan 2020 23:42:17 GMT

Hi,

Could you please share 5 sample input and lookup records along with current job flow and mapping screenshots? Please also specify expected output data. I will try it from my end.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved