topic Re: Unparseable date csv in Talend Studio

Unparseable date csv

Anonymous — Sat, 16 Nov 2024 08:47:10 GMT

Hello, community:

I'm having some problems with the csv file I have in my project, when I run the project it says "Unparseable date..." and the rows doesn't go to the next step that is treplicate.

I can't explain it to myself because I have been working with the same file and I had no problems until today.

I tried to resolve it by uploading again the same file and I can't figure why it is not working.

Here I leave the file I uploaded and the screenshot of the problem.

I hope somebody could help me.

Best regards.

Re: Unparseable date csv

Anonymous — Wed, 31 Jan 2018 05:29:58 GMT

Please open your csv in notepad or notepad++ and verify the date format.

Re: Unparseable date csv

Anonymous — Wed, 31 Jan 2018 07:55:13 GMT

Hello,

Your input source data doesn't map any date pattern. Which component do you use to read this CSV file? Could you please show us your current job setting screenshot?

Best regards

Sabrina

Re: Unparseable date csv

Anonymous — Wed, 31 Jan 2018 16:00:07 GMT

I think it's very strange, because it worked the day before yesterday.

I added a new column and it worked, I'm still using the same csv file

Thank you so much for your help.

Best regards,

Daniela

Re: Unparseable date csv

Anonymous — Wed, 31 Jan 2018 16:04:45 GMT

I feel so stupid because I was using in the talend the format "-" and I had the csv file with "/", that's why it didn't work, I already changed it in "edit schema".

Thank you so much!