topic multiple if conditions in tmap in Talend Studio

multiple if conditions in tmap

Anonymous — Sat, 16 Nov 2024 03:40:33 GMT

Hi All,

I have a requirement to transform the data from source to target. below is the requirement.

In T_USER_DIM the column will have 3 possible values: value null when st_user.external_employee=1. value ‘y' when st_user.external_employee=0 and the st_user.external_id is found in st_us_persons. value 'n’ when st_user.external_employee=0 and the st_user.external_id is not found in st_us_persons.

i have written expression like this in tmap, but it is not working.

(ST_USER.external_employee=="1")?"Null" : ( ( ST_USER.external_employee == "0")?"Y":"N"

Re: multiple if conditions in tmap

PLITDT — Mon, 06 Jan 2020 09:37:22 GMT

Hi,

To check if st_user.external_id exists in st_us_person you will need to join on that table. You can then check if the external_id is null or not.

If the data type of the column st_user.external_employee is an integer, there is no need to surround 1 or 0 with quotes in the conditional statements. If it is a String, you have to use st_user.external_employee.equals("1") instead.

Try this and see if it works:

st_user.external_employee == 1 ? null:
st_user.external_employee == 0 && st_us_persons.external_id != null ? "Y":
st_user.external_employee == 0 && st_us_persons.external_id == null ? "N" : "X"

Re: multiple if conditions in tmap

Anonymous — Mon, 06 Jan 2020 13:36:25 GMT

Hi @plID,

Thank you for your response,i have a join between these 2 tables and the data type of the column st_user.external_employee is Varchar. i have one more question, do we need to enclose the statements in braces or simply adding the condition in the expression editor will work.

Re: multiple if conditions in tmap

karthikj18 — Mon, 06 Jan 2020 20:31:47 GMT

Both works. Make sure that you are using correct braces in multiple if conditions.

Re: multiple if conditions in tmap

Anonymous — Tue, 07 Jan 2020 08:44:05 GMT

@karthikj18 ,

expression is throwing error, below is the screenshot.

Re: multiple if conditions in tmap

Anonymous — Tue, 07 Jan 2020 09:09:54 GMT

my source column is string datatype and my target is character, how to fix this

Re: multiple if conditions in tmap

PLITDT — Wed, 08 Jan 2020 10:08:45 GMT

Hi,

To check whether one String is equal to another you cannot use the operator "==". Instead you should use st_user.external_employee.equals("1"). To convert a String into a char you can use the mystring.charAt(0) method. Make sure to check if the variable is null or not first as you cannot call this method on a null value.

Taken together, try to create a variable in the tMap to do the multiple conditions and then convert to char in the expression field of the output mapping (see below).

Re: multiple if conditions in tmap

Anonymous — Thu, 09 Jan 2020 09:50:03 GMT

Hi @plID ,

Thank you for your response, i have made changes you mentioned, but still i'm getting this erroranges like you

Re: multiple if conditions in tmap

manodwhb — Thu, 09 Jan 2020 10:03:25 GMT

@keshav1991 , can you check the check box for key for us_person filed in output section of tMap?

Re: multiple if conditions in tmap

Anonymous — Thu, 09 Jan 2020 10:20:00 GMT

Hi @manodwhb ,

I have done that as well but no luck.

Re: multiple if conditions in tmap

manodwhb — Thu, 09 Jan 2020 10:22:40 GMT

@keshav1991 , can you unchecked the key check box in tmap of input field of external_id .

Re: multiple if conditions in tmap

Anonymous — Thu, 09 Jan 2020 10:34:33 GMT

no it is checked only...