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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unparseable date error while run a job

I am using the below as source data and i am not doing any transformations in my job , just loading data in to target file as CSV, But for date column alone i am getting the Error as "Unparseable date: "2019-05-15 06:30:00"". Might be it may be basic, but i am new to this tool , could any one help me to solve this 

my source data as in below format 

0683p000009M5z7.png0683p000009M5zC.png

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi,

 

in the input of tMap for the date column, use the below format.

 

"yyyy-MM-dd HH:mm:ss".

 

The input date as per your screenshot is of above format.

 

Thanks and Regards,

Subhadip

Anonymous
Not applicable
Author

Use the same for output as well.

 

If you need any specific format of date, use date functions to convert to the specific format.

 

Thanks and Regards,

Subhadip