Skip to main content
Announcements
Marching toward a simplified navigation! READ ON

Qlik Replicate: Error with Date column during dataload

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
narendersarva
Support
Support

Qlik Replicate: Error with Date column during dataload

Last Update:

Jun 21, 2023 6:01:24 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jun 21, 2023 6:01:24 AM

A Qlik Replicate task fails with:

Error while reading data, error message: Could not parse 'attNULL' as TIMESTAMP for field first_regstn_dt (position 5) starting at location 32662479 with message ''attNULL' is null for required field'
You are loading data without specifying data format, data will be treated as CSV format by default. If this is not what you mean, please specify data format by --source format.

 

Resolution:

Add a CASE statement to the date timestamp. Example:

coalesce(
CASE WHEN substr($first_regstn_dt,1,4) = '0000'
THEN '1999/01/01'
WHEN substr($first_regstn_dt,1,4) = '0'
THEN '1999/01/01'
WHEN substr($first_regstn_dt,1,4) = ''
THEN '1999/01/01'
ELSE
$first_regstn_dt
END
,$first_regstn_dt)

Then stop and resume the task. This will pick up the task without error. 

Labels (1)
Version history
Last update:
‎2023-06-21 06:01 AM
Updated by: