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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Unparseable date: ""

Hi,
I'm getting the source data from the txt file and loading into the database table.
While loading I'm getting the below error.

java.lang.RuntimeException: java.text.ParseException: Unparseable date: ""
    at routines.TalendDate.parseDate(TalendDate.java:858)
    at routines.TalendDate.parseDate(TalendDate.java:802)
    at ext_ent.t_distributor_0_1.t_distributor.tFileInputDelimited_1Process(t_distributor.java:1360)

Source data and parseDate that I'm using in the tmap and below is the screenshot.
Can anyone please let me know if anything is wrong
1992/08/23  - TalendDate.parseDate("YYYY/MM/dd",distributor.DSTRB_STRT_DATE)
9999/12/31  - TalendDate.parseDate("YYYY/MM/dd",distributor.DSTRB_END_DATE)

01/25/94  - TalendDate.parseDate("MM/dd/yy",distributor.LAST_UPD_TSTMP)


0683p000009MH6W.png

Thanks

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

That is caused because the date you are trying to parse is an empty String. 

View solution in original post

2 Replies
Anonymous
Not applicable
Author

That is caused because the date you are trying to parse is an empty String. 
Anonymous
Not applicable
Author

Thank you!Resolved the problem