Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
shivb
Contributor
Contributor
‎2020-10-23 06:03 AM

Invalid Date value

Hello ,

Purpose of the current job we have is to do date validation of DATE field values across tables. We have a dynamic load process going on. So the tables are created with DATE fields like VARCHAR2(30) as data type. While using TalendDate.isDate routine, we never had any issues. However recently 4 records are getting rejected. Rest of the records with similar date values do not get rejected. We have validated and found there are no spaces in those values. The encoding of CSV file is in UTF-8 format.

0693p00000AF0OoAAL.png

very difficult to identify where the issue is. Anyone has encountered such a situation?

Labels (4)
80 Views
0 Likes
0 Replies