Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

Field Not Found

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

Labels (1)
1 Reply
Or
Champion
Champion

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.