topic Re: tmap error in Talend Studio

tmap error

Anonymous — Sun, 26 Nov 2017 07:45:31 GMT

Hi,

Can any one help me to resolve issue...While running a job i m getting a error like

Starting job MyFirstTalendJob at 13:08 26/11/2017.

[statistics] connecting to socket on port 3587
[statistics] connected
Unparseable date: "01-Mar-2012"
Unparseable date: "05-Jun-2010"
Unparseable date: "22-Jun-2010"
Unparseable date: "05-Apr-2010"
Unparseable date: "13-Sep-2009"
Unparseable date: "14-Dec-2011"
Unparseable date: "30-Feb-2011"
Unparseable date: "07-Nov-2009"
Unparseable date: "22-Dec-2012"
Unparseable date: "28-May-2011"
[statistics] disconnected
Job MyFirstTalendJob ended at 13:08 26/11/2017. [exit code=0]

Re: tmap error

Anonymous — Sun, 26 Nov 2017 23:04:46 GMT

You have to verify whether the date field is null or not. For example:

yourDateColumn!=null && !"".equalsIgnoreCase(yourDateColumn)? TalendDate.parseDate("yyyy/MM/dd'T'hh:mm:ss",yourDateColumn) :null

Re: tmap error

Anonymous — Tue, 28 Nov 2017 08:20:43 GMT

Hello,

Could you please post your current job design screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Re: tmap error

Anonymous — Wed, 29 Nov 2017 12:47:45 GMT

In your tmap leftside and rightside schema column has any date value, Just change Type-->Date and

Give DatePattern->"MM/dd/yyyy"(you can give date patern as you want).