topic Re: IF/ELSE condition in Talend in Talend Studio

IF/ELSE condition in Talend

REjaz1662272866 — Fri, 15 Nov 2024 22:34:52 GMT

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 — Wed, 07 Sep 2022 07:06:36 GMT

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

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

REjaz1662272866 — Wed, 07 Sep 2022 10:12:00 GMT

The data type is string in my case.

Anonymous — Wed, 07 Sep 2022 10:39:19 GMT

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 — Wed, 07 Sep 2022 14:35:12 GMT

Worked great. Thankyou!

ThWabi — Wed, 07 Sep 2022 15:46:36 GMT

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