topic Re: Help with IF/Else statement in Talend Studio

Help with IF/Else statement

JM39 — Sat, 16 Nov 2024 02:21:27 GMT

Hello

I'm trying to get help on this if/else statement. I don't really know what I'm doing when I need to include more than one condition. This is my statement

row8.Code.equals("AE") ? null :
row5.CONTACT_ADD3 :
row5.CONTACT_ADD3.equals(null)?
row5.CONTACT_POSTCODE :
row5.CONTACT_ADD3+", "+row5.CONTACT_POSTCODE

So I'm trying to say

If Code = AE then make the field null, else

Use contact_add3, else

If contact_add3 is null then use contact_postcode, else

use contact_add3 + contact_postcode

I'm getting the error in the screenshot. Thank you so much for help.

Re: Help with IF/Else statement

TRF — Fri, 22 May 2020 13:00:58 GMT

row8.Code.equals("AE") ? null :
row5.CONTACT_ADD3 == null ?
row5.CONTACT_POSTCODE :
row5.CONTACT_ADD3 + ", " + row5.CONTACT_POSTCODE

Re: Help with IF/Else statement

Anonymous — Fri, 22 May 2020 22:56:44 GMT

Use this it will work

row8.Code.equals("AE") ? null :
Relational.ISNULL(row5.CONTACT_ADD3) ? row5.CONTACT_POSTCODE : row5.CONTACT_ADD3 + ", " + row5.CONTACT_POSTCODE

Re: Help with IF/Else statement

TRF — Sat, 23 May 2020 10:05:51 GMT

Did this help? If so, thanks to mark your case as solved (Kudo also accepted)

Re: Help with IF/Else statement

JM39 — Mon, 25 May 2020 12:05:29 GMT

Got that working now - thank you both!