Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

The cell format is not Date in ( Row. 1 and ColumnNum. 12 )

Hello,

I'm trying import excel file to SQL Server and Talend is not recognizing Date Format. Then value from date cell in Excel is coming from formula. If I change the formula for a fixed value in the same format, Talend import the data without any problem.

 

0683p000009MaLb.png

I've read all topics about this problem, and in any topics I found the solution related with expression in tMap.I made the expression TalendDate.parseDate, but without success.

 

Below my package and metadata.

0683p000009MaLg.pngMy package

0683p000009MaLl.pngmetadata

 

Any idea?

Labels (2)
2 Replies
Prakhar1
Creator III
Creator III

What you can do first try to read it as String from Excel and then in tMap cast it to Date and change it's format as well.

 

Don't forget to give Kudos and Accept it as Solution if I helped you Smiley Happy

Prakhar1
Creator III
Creator III

What you can do first try to read it as String from Excel and then in tMap cast it to Date and change it's format as well.

 

Don't forget to give Kudos and Accept it as Solution if I helped you Smiley Happy