topic Re: How to do if/else statement in tmap in Talend Studio

How to do if/else statement in tmap

JM39 — Sat, 16 Nov 2024 02:33:57 GMT

Hello, I'm very new to Talend and I'm struggling with how to get this correct. For the output in a particular column, I want that derived based on the value in another column. So,

If the value in the contact type = EMRG then set the emergency contact flag to yes, else no. I've written it like the attached screenshot

The job runs and produces the output, but all the values in the emergency contact flag column are set to N, even though there are contact types of EMRG.

Where exactly am I going wrong? I'm very new to Talend. Thank you!

Re: How to do if/else statement in tmap

TRF — Tue, 28 Apr 2020 13:24:15 GMT

Never use == to compare Strings.

Instead use the following expression:

"EMRG".equals(row11.CONTACT_TYPE) ? "Y" : "N"

Re: How to do if/else statement in tmap

JM39 — Tue, 28 Apr 2020 14:10:49 GMT

Thank you so much - that worked like a dream!