topic Re: IF/else statement usage in tMap in Talend Studio

IF/else statement usage in tMap

Anonymous — Wed, 27 Mar 2013 14:53:01 GMT

Hi - I have a problem in applying the if/else condition in tMap. I am trying to do below validations in tMap.
if (in.stop_seq == 1 && in.message_status == 10 && in.message_type == 40) 'AA'
else if (in.stop_seq == 1 && in.message_status == 10 && in.message_type == 45) 'X3'
else if (in.stop_seq == 1 && in.message_status == 10 && in.message_type == 50) 'AF'
else if (in.stop_seq == 2 && in.message_status == 10 && in.message_type == 40) 'AB'
else if (in.stop_seq == 2 && in.message_status == 10 && in.message_type == 45) 'X1'
else if (in.stop_seq == 2 && in.message_status == 10 && in.message_type == 50) 'CD'
My source is a db2 and trying to populate a output filed based on this condition. As am new to this, tried all possible options but didn't work. Could you please help?
Note:In my screenshot attached, i tried with one input value to check and populate the target.
Thanks in advance!!!

Re: IF/else statement usage in tMap

Anonymous — Wed, 27 Mar 2013 15:05:00 GMT

In the tmap, the formula must return a value that will be assigned to the output column of your schema. Then, you can't use if/then/else statements in it.
Instead, use conditional operator "?" like this :
(condition) ? then_value : else_value
For your example :
(in.stop_seq == 1 && in.message_status == 10 && in.message_type == 40) ? "AA" :
((in.stop_seq == 1 && in.message_status == 10 && in.message_type == 45) ? "X3" :
((in.stop_seq == 1 && in.message_status == 10 && in.message_type == 50) ? "AF" :
...
((in.stop_seq == 2 && in.message_status == 10 && in.message_type == 50) ? "CD" : null)))

Re: IF/else statement usage in tMap

Anonymous — Wed, 27 Mar 2013 15:19:41 GMT

Boulayj - Thanks a lot!! It really worked. Could you please let me when to use if/elseif & ?: in tMap expression?
I am really new to Java..learn the things. Once again your help is greatly appreciated.:-)

Re: IF/else statement usage in tMap

Anonymous — Wed, 27 Mar 2013 15:48:25 GMT

You must always use conditional operator "?" in tMap expression.
If you want to use if/then/else (for a more complex expression) then you have to create your own routine and to use it in the tmap expression. A routine is a java method that must return a value.

Re: IF/else statement usage in tMap

Anonymous — Fri, 29 Mar 2013 03:09:39 GMT

talend generate java script and when you put a value in the interface field it write myField = your_value;
you can use routine or the simplify syntax of java but you cant use function or other condition.
when u change something u can see the java code in the code tab of the job, if there is red line u have bad entry in a component. it s very important for the data type

Re: IF/else statement usage in tMap

Anonymous — Tue, 02 Apr 2013 20:05:06 GMT

NO, Talend does not create Java Script!!. JavaScript != Java. Its only the name, nothing else.
It would be correct to write "Talend generate java code..."
By The Way, this post is in the wrong category!

Re: IF/else statement usage in tMap

Anonymous — Wed, 03 Apr 2013 03:53:32 GMT

Hi nboulic,
Thanks for sharing your experience of using tMap component with us(exactly, Talend generates Java code). In addition, for the user routine mentioned by @boulayj, please refer to How+to+create+user+routines and Calling+a+routine+from+a+Job
Best regards
Sabrina

Re: IF/else statement usage in tMap

Anonymous — Mon, 13 Apr 2015 14:24:24 GMT

Hi All....
I am facing problem in 'if then elsif condition'
as while if statement is true at that time else also execute and it directly execute else statement instead of elsif statement.

Re: IF/else statement usage in tMap

Anonymous — Tue, 14 Apr 2015 11:32:30 GMT

Hi salvekaran_1,

I am facing problem in 'if then elsif condition'
as while if statement is true at that time else also execute and it directly execute else statement instead of elsif statement.

Could you please set an example for your requirment?
Best regards
Sabrina

Re: IF/else statement usage in tMap

Anonymous — Tue, 14 Apr 2015 15:55:03 GMT

Hello Sabrina,
I wanna define multiple conditions in tMap Component just like that following example,
if Employees.Department_id != Department.Department_id Then Print "Department ID is not valid"
if Employees.Department_id == Department.Department_id Then Print "null"
if Employees.Job_Id != Jobs.Job_Id Then Print " Job ID is not Valid"
if Employees.Job_Id == Jobs.Job_Id Then Print "null"
I' wrote this type of condition in tMap Expression , is it right ya wrong please notify me.
row1.DEPARTMENT_ID!=row2.DEPARTMENT_ID ? "Error_1" :
row1.DEPARTMENT_ID ==row2.DEPARTMENT_ID ? null :
row1.JOB_ID !=row3.JOB_ID ? "Error_2" :
row1.JOB_ID ==row3.JOB_ID ? null :
row1.HIRE_DATE != row1.HIRE_DATE)? "Error_3" :null
Thanks
Kiran Salve
ValuD Software's

Re: IF/else statement usage in tMap

Anonymous — Wed, 15 Apr 2015 07:26:32 GMT

Hi Kiran,
Seems everything ok but add row1.HIRE_DATE.compareTo(row2.HIRE_DATE)!=0 in your expression.
Then your Expression became like below after include above logic.
row1.DEPARTMENT_ID!=row2.DEPARTMENT_ID ? "Error_1" :
row1.DEPARTMENT_ID ==row2.DEPARTMENT_ID ? null :
row1.JOB_ID !=row3.JOB_ID ? "Error_2" :
row1.JOB_ID ==row3.JOB_ID ? null :
row1.HIRE_DATE.compareTo(row2.HIRE_DATE)!=0? "Error_3" :null
Regards,
Kumar

Re: IF/else statement usage in tMap

Anonymous — Wed, 15 Apr 2015 07:40:32 GMT

Hi salvekaran_1,

I think u meant to say that, filtering based on ur 5 condition using expression filter ?? if so ur doing it in wrong way

Re: IF/else statement usage in tMap

Anonymous — Wed, 15 Apr 2015 08:25:42 GMT

try below statement

Employees.Department_id != Department.Department_id? "Department ID is not valid" : Employees.Department_id == Department.Department_id? "null": Employees.Job_Id != Jobs.Job_Id? " Job ID is not Valid":Employees.Job_Id == Jobs.Job_Id?"null":"null"

Re: IF/else statement usage in tMap

Anonymous — Wed, 15 Apr 2015 12:21:50 GMT

Hi Umesh,
I tried above statement in tMap Expression but it's not working properly please check below screenshot

Re: IF/else statement usage in tMap

Anonymous — Fri, 28 Aug 2015 06:39:23 GMT

Hi,
I have situation in tMap.
I have 2 columns STARTDATE & ENDDATE . i just want to validate that STARTDATE should not be greater than ENDDATE &
ENDDATE should not be less than STARTDATE.
WILL YOU PLEASE HELP ME TO IMPLEMENT THIS LOGIC.
Both columns are type DATE .
Thanx in advance.

Re: IF/else statement usage in tMap

Anonymous — Fri, 28 Aug 2015 07:54:59 GMT

you can use below function to check whether your date is greater than End date or not.
Operation: StartDate>EndDate && EndDate>StartDate

row4.STARTDATE != null && (row2.STARTDATE.before(row4.ENDDATE))

This will check whether Start Date is before ENDDATE. that means it is lesser than EndDate.
You can check other Date functions here. talend-date-routine-function-with-examples

Re: IF/else statement usage in tMap

Anonymous — Fri, 28 Aug 2015 08:13:58 GMT

Hi Shri_Kul1,
You can create a tMap variable to carry out the logic on the dates and then use that variable to direct the flow to the output table you want.
Please see my screenshot for detail. Feel free to let us know if it is OK with you.
Best regards
Sabrina

Re: IF/else statement usage in tMap

Anonymous — Fri, 28 Aug 2015 10:57:06 GMT

Hi Sabrina & Umesh ,
Actual scenario is .... the fields i have mentioned (STARTDATE & ENDDATE) are coming from the same table , there is no look up table , but there is 2 target table that are for good data and for bad data,
in Bad data table there should be only null or the data which is failed at the validation .
so in this case i want "Start Date should not be greater than End date " & "End date should be greater than Start Date" @ the Bad table.
Fields datatype is "Date" in source table .
waiting for reply...!!!!
Thanks

Re: IF/else statement usage in tMap

Anonymous — Fri, 28 Aug 2015 11:45:01 GMT

In that case you can use below statement respectively for each good and bad flow.
This one is for Good Data.

row4.STARTDATE != null && (row2.STARTDATE.before(row4.ENDDATE))

And this one is for bad data.

(row4.STARTDATE != null && (row2.STARTDATE.after(row4.ENDDATE))) || row4.STARTDATE == null

Hope this will solve your problem.

Re: IF/else statement usage in tMap

Anonymous — Fri, 28 Aug 2015 14:37:02 GMT

Its Working ....
Thanx Umesh...