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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

DATE DATA TYPE (UNPARSED DATE ERROR)

hi all,
i am new to talend
My sourece is csv, there in date column i have date date in "MM/DD/YYYY" pattern,
when tried that to load in staging table . I am getting the error "UNPARSED DATE"
My db is oracle here defaoult pattern is dd-mm-yyyy, i tried talend.parsedate in tmap also
any help.....
Labels (2)
11 Replies
Anonymous
Not applicable
Author

tfileinputdelimited | ---> toracleoutput
(for the date field | (for the datefield set the date pattern "dd-MM-YYYY" in toracleoutput schema)
set date pattern to |
"MM/dd/YYYY" in the
tfileinputdelimited
schema)
what is the error shown? copy-paste the err msg
Anonymous
Not applicable
Author

Are there null values or other wrong data in your source file?