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