IF/ELSE condition in Talend

[REjaz1662272866]

Hey!

Can someone please how to conduct an else if function while comparing 2 variables? Eg: 'If beginningdate < endingdate, write T or else write F.

Please note, I don't want to compare a any variable with an integer, but I want to compare actual two variables present in my schema.

[Anonymous]

if the data type is Date, then you can write the expression like this:

row1.beginningdate.getTime()<row1.endingdate.getTime()?"T":"F"

[REjaz1662272866]

The data type is string in my case.

[Anonymous · Accepted solution]

the operator < does not work with string type, you need to convert string data to Date,

TalendDate.parseDate("yyyy-MM-dd",row1.​beginningdate).getTime()<TalendDate.parseDate("yyyy-MM-dd", row1.endingdate).getTime()?"T":"F"

//"yyyy-MM-dd" is the date pattern, change it based on your real date format.

[REjaz1662272866]

Worked great. Thankyou!

[ThWabi]

Hello REjaz1662272866,

a solution (without .getTime()) might be:

TalendDate.compareDate(TalendDate.parseDate("yyyy-MM-dd", row1.beginningDate), TalendDate.parseDate("yyyy-MM-dd", row1.endingDate)) < 0 ? "T" : "F"

Best regards,

Thomas