Field 'ID_DATE_NUM' not found

[Asero]

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

[edwin]

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?