Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try running just the SQL as the preceding load looks to be right.
Check if its due to missing keyword 'SQL' before the SELECT?