multiple if conditions in tmap

[Anonymous]

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"

[manodwhb]

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

[Anonymous]

no it is checked only...