Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Any idea?
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
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