Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unparseable date csv

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.

0683p000009LspD.png0683p000009LsUp.png

 

I hope somebody could help me.

 

Best regards.

 

 

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

0683p000009LsZW.png

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

 

Thank you so much for your help.

 

Best regards,

Daniela

Anonymous
Not applicable
Author

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".0683p000009Lsa5.png

 

Thank you so much!