topic Re: Help me with the logic for TMAP Please in Talend Studio

Help me with the logic for TMAP Please

DEV4 — Sat, 16 Nov 2024 05:13:20 GMT

Hello All,

Can you please help me how to achieve the below scenario.I need to write the condition in TMAP.

If Column A =1 and rest of columns B,C,D are 0, then target column should be populated with 'Applicant'.

If Column A and B =1 and rest of columns C,D are 0, then target column should be populated with 'Admit'.

If Column A and B and C =1 and rest of column D IS 0, then target column should be populated with 'Commit'.

If all columns A,B,C,D are = 1, the the target column should be populated with 'Net Commit'.

Thanks

Re: Help me with the logic for TMAP Please

mani1304 — Sat, 20 Jul 2019 02:57:31 GMT

I am assuming A,B,C,D as input column and there is only one output column, which can have the given values, so you can use if condition to assign values to the output column as per the condition and assign null if non match, like below

(input_row.A==1)&&(input_row.B==0)&&(input_row.C==0)&&(input_row.D==0)?"Applicant":

(input_row.A==1)&&(input_row.B==1)&&(input_row.C==0)&&(input_row.D==0)?"Admit":

(input_row.A==1)&&(input_row.B==1)&&(input_row.C==1)&&(input_row.D==0)?"Commit":

(input_row.A==1)&&(input_row.B==1)&&(input_row.C==1)&&(input_row.D==1)?"NetCommit":null

Re: Help me with the logic for TMAP Please

DEV4 — Sat, 20 Jul 2019 03:57:34 GMT

Thank you so much. I just implemented this logic and I was able to achieve my requirement. And yes the target column is only one column.