topic Re: Date column Null Tmap in Talend Studio

Date column Null Tmap

Anonymous — Fri, 20 Jul 2018 16:43:35 GMT

Hi,

I am facing an issue with Date Column conversion.

I have multiple date column "YYYY-MM-DD"

Flow of Talend job

Input (.txt file)-->tmap-->Snowflake table.

I have done variable conversion in tmap :

TalendDate.isDate(row5.Column0,"yyyy-MM-dd") ? TalendDate.parseDate("yyyy-MM-dd", row5.Column0) : null

I am facing runtime error:

Input String : NULL

Please help me to resolve this.

aashish_21nov — Sat, 21 Jul 2018 05:59:40 GMT

this error only comes when your input string is null.

Anonymous — Sat, 21 Jul 2018 21:19:12 GMT

Hi,

Please add a null condition check as the first step to avoid the error. Sample code is as below.

!Relational.ISNULL(row5.Column0)?
(TalendDate.isDate(row5.Column0,"yyyy-MM-dd") ? TalendDate.parseDate("yyyy-MM-dd", row5.Column0) : null) : null

If the suggestion given has helped you, could you please mark the topic as solution provided?

Warm regards,

Nikhil Thampi

Anonymous — Wed, 25 Jul 2018 14:25:39 GMT

Hey ,

Thanks for your help.

Worked fine with the below code :

TalendDate.isDate(row5.Column0,"yyyy-MM-dd hh:mm:ss.SSS") ? TalendDate.parseDate("yyyy-MM-dd hh:mm:ss.SSS", row5.Column0) : null

I guess the issue was with other columns .

Thank you.