Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Asero
Contributor
Contributor

Field 'ID_DATE_NUM' not found

Am trying to run below script but its giving me Field 'ID_DATE_NUM' not found error. Below is the script please help

 

PDT_DTL :

Load *,Date(Date#(ID_DATE_NUM,'YYYYMMDD'),'DD/MM/YYYY') as REPORTING_DT,
num(Date(Date#(ID_DATE_NUM,'YYYYMMDD'),'DD/MM/YYYY')) as %KeyDate;

SELECT
CAT,
ID_DATE_NUM,
ID_DATE,
REVN_SUB_TYPE,
RGN,
AREA,
OS,
SGMN,
SUBS,
SUB_MPS,
VOL,
VOL_MPS,
VAL,
VAL_MPS,
REV,
REV_MPS
FROM
TEMP_DASH_2022

Labels (1)
2 Replies
edwin
Master II
Master II

try running just the SQL as the preceding load looks to be right.

Digvijay_Singh

Check if its due to missing keyword 'SQL' before the SELECT?