Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Never use == to compare Strings.
Instead use the following expression:
"EMRG".equals(row11.CONTACT_TYPE) ? "Y" : "N"
Never use == to compare Strings.
Instead use the following expression:
"EMRG".equals(row11.CONTACT_TYPE) ? "Y" : "N"
Thank you so much - that worked like a dream!