Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When below code is executed in Qlik Script daily, Sometimes the script runs successfully and sometimes it throws below mentioned error and fails.
Qlik Script:
Load DateColumn as Count_Row_Date,
Count_Row_Num
select top 1
cast(LDateUTC as date format 'YYYYMMDD') as DateColumn,
sum(1) as Count_Row_Num
from FactTable
group by 1
order by 1 desc;
ERROR MESSAGE
Error: Field 'DateColumn' not found
I'd guess that something is causing the SQL to not return anything, possibly some sort of error that the connector doesn't catch. As a result, the load can't find the field from the Select. You could cross-check your database logs to see whether the query is executing successfully at the specified time.