Issue with Date in tfileInputExcel

Highlighted
Six Stars

Issue with Date in tfileInputExcel

Hello,

 

I have an xlsx input file with a date field format "dd/MM/yyyy".

If I open the fie with Excel, I have the correct date, like "25/01/2018". 

However, When using tFileInputExcel component to use this file in Talend Job, this same value transforms itself, with no component to do so in someting like, "02/01/0020"

I'm not sure where the problem is here and I've no idea where to go from there as it corrupt the whole job

 

Regards,

 

C.

 


Accepted Solutions
Highlighted
Six Stars

Re: Issue with Date in tfileInputExcel

Hello,

 

Now that I know that the Date format Talend gets in input isn't the one I actually see in my excel file, I'm able to get the format I want with a simple parseDate.

Thanks for the help.

 

Regards,

 

C.

View solution in original post


All Replies
Moderator

Re: Issue with Date in tfileInputExcel

Can you open excel file in notepad++ and check the date format and specify the same format in job too
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Six Stars

Re: Issue with Date in tfileInputExcel

Hello,

Thanks for the quick answer.

If it was a csv file I could, but if I try with xlsx file, it's appears completely encrypted on notepad++

I tried to save xlsx file to csv manually and then open with notepad++ and the format appears correctly. Unfortunaltely I can't do that for the job as it'll have to run daily and I will not have access to input before it arrives in job.

 

I tried to change tFileInputExcel schema from Date to string ans see what the content is in tlogRog, and it appears like this 2/25/18 instead of 02/25/2018 which may be the source of this issue.

 

Regards,

 

C.

Highlighted
Moderator

Re: Issue with Date in tfileInputExcel

Yes..when you try to read as sting,you were seeing in 2/25/18 format right? Then,while generating the excel file format has not specified 02/25/2018 format.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Six Stars

Re: Issue with Date in tfileInputExcel

Hello,

 

Now that I know that the Date format Talend gets in input isn't the one I actually see in my excel file, I'm able to get the format I want with a simple parseDate.

Thanks for the help.

 

Regards,

 

C.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Talend Cloud Developer Series – Updating Context Variables

This video will show you how to add context parameters to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now

Talend Cloud Developer Series – Fetching Studio License

This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License

Watch Now