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.
