topic Re: How to select last populated column in tmap in Talend Studio

How to select last populated column in tmap

JM39 — Sat, 16 Nov 2024 02:13:20 GMT

Hello. I'm trying to get the last populated column from my source data in some address fields. This is my expression

row1.Address4!=null ? row1.Address4 :
row1.Address4==null ? row1.Address3 :
row1.Address3==null ? row1.Address2

What I'm trying to say is

If address4 is not null, use address4 ELSE

If address4 is null, use address3 ELSE

If address3 is null, use address2

It seems to work for all records except those where address2 is the last one populated in the source data & it's returning null values. Any help appreciated. Thanks you

Re: How to select last populated column in tmap

akumar2301 — Fri, 05 Jun 2020 19:44:40 GMT

Modify like this
If address4 is not null, use address4 ELSE
If address3 is not null , use address3 ELSE
If address3 is null, use address2

Re: How to select last populated column in tmap

JM39 — Fri, 05 Jun 2020 19:53:35 GMT

Perfect thank you! It still didn't work actually and then I realised that I also have null values in addr2. I tried this way and it worked:

row1.Address4 !=null ?
row1.Address4 :
row1.Address3 !=null ?
row1.Address3 :
row1.Address2 !=null ?
row1.Address2 : null

Thank you so much 🙂