Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm new to this community. I'm trying to do a simple resident load but Qlik simply won't let me. I have used resident load 3 other times in my script but this one time it just does not work with Qlik throwing an error: Unknown statement: RESIDENT TransactionTableTemp.
Can anyone help please?
[TransactionTableTemp]:
LOAD "STOCK_CODE" As "Stock Code",
"PROCESS_DATE" As "Process Date",
"QUANTITY_ISS" As "Issue Qty",
"ISSUE_REQ_NO" As "Requisition No.",
"WORK_ORDER" As "Transaction Work Order",
"IREQ_TYPE" As "Requisition Type";
SQL "SQL codes";
[Stock Code Age]:
LOAD "Stock Code",
MIN("Process Date") As "Days Since First Receipt";
Resident [TransactionTableTemp]
GROUP BY "Stock Code";
DROP Table [TransactionTableTemp];
Thanks in advance!
There is a typo in your code. Just remove the semicolon before Resident (below in red):
Stock Code Age]:
LOAD "Stock Code",
MIN("Process Date") As "Days Since First Receipt";
Resident [TransactionTableTemp]
GROUP BY "Stock Code";
JG
There is a typo in your code. Just remove the semicolon before Resident (below in red):
Stock Code Age]:
LOAD "Stock Code",
MIN("Process Date") As "Days Since First Receipt";
Resident [TransactionTableTemp]
GROUP BY "Stock Code";
JG
Thanks! Rookie mistake 🙂
Hi,
please close your thread by accepting an answer as solution.
thanks
Marco