tmap error

[Anonymous]

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]

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi

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).