topic Re: IF with isdate checking in Talend Studio

IF with isdate checking

azrylln — Wed, 25 Jul 2018 09:15:18 GMT

Hi there,

I am a newbie to talend. I want to ask you, how to do this item below:

I want to check the validity of a given date from an input table. If the date is a valid date, then the date will be inserted to output table. if it is not a valid date, then space will be inserted to the column. Both the input and output column are date field and my codes are as below:

TalendDate.isDate(TalendDate.formatDate("dd-MM-yyyy",row1.birthdate),"dd-MM-yyyy")?row1.birthdate:""

when rebuilding, i got this compilation error: >> Type mismatch: cannot convert from String to Date

please help me to solve this issue.

I am also open to ideas on how to make this process easier using Talend.

Thank you in advance for helping me.

Re: IF with isdate checking

Anonymous — Wed, 25 Jul 2018 09:23:17 GMT

I suspect that the data type of the row1.birthdate column is String and not Date. The formatDate method requires as Date. All you need to do is this....

  TalendDate.isDate(row1.birthdate,"dd-MM-yyyy")?row1.birthdate:""

Of course, your row1.birthdate column will need to hold the date in "dd-MM-yyyy" format. I'd advise adding a tLogRow before the component you are using this logic in, so that you can see what the date format is of your String.

Re: IF with isdate checking

aashish_21nov — Wed, 25 Jul 2018 10:02:23 GMT

Hi @azrylln

you getting this error due to formatDate function which return string data type accept only Date type value. So as @rhall suggest you can use isDate function directly with your birthdate or if your date is in different pattern use parseDate function.

Re: IF with isdate checking

Anonymous — Wed, 25 Jul 2018 10:22:16 GMT

@aashish wrote:

Hi @azrylln

you getting this error due to formatDate function which return string data type and isDate function accept only Date type value. So as @rhall suggest you can use isDate function directly with your birthdate or if your date is in different pattern use parseDate function.

This is not true. The isDate method requires two Strings (stringDate and pattern). There is absolutely no point to the isDate method if it accepts a Date object. A Date object is a Date or null.

Re: IF with isdate checking

aashish_21nov — Wed, 25 Jul 2018 10:37:49 GMT

yeah @rhali its typo