I am trying to import .txt file into MySQL database, and all columns are being imported but I am having an issue with the date where the year is showing 0015 or 0016 instead of 2015 or 2016.
The date column in the .txt file
What is being imported into the database:
I tried ParseDate, FormatDate and even without expression but doesn't seem to solve it.
What am I doing wrong ?
Solved! Go to Solution.
Could you be a little more precise?
Like which product are you using? Which version?
If it's Studio, capture (at least) of your job?
Thanks for quick reply!
I am using Talend Open Studio for Data Integration Version: 6.4
And this is the job i am doing:
So, you're using the Studio, that's good to know.
Could add more information, like the original file, the job?
the original file is a .txt and Date column as "dd-MMM-yyyy" as I added also as Metadata delimited file.
And Tmap as follows without any expression:
It is importing month and day correctly but the year is starting with 00 instead of 20 (0016 instead of 2016)
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to enable Data Governance
Take a peek at the definitive guide to Government Data Quality