Issue with using Resident Load

[QlikNewLearner1]

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!

[JuanGerardo · Accepted solution]

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

[QlikNewLearner1]

Thanks! Rookie mistake 🙂

[MarcoWedel]

Hi,

please close your thread by accepting an answer as solution.

thanks

Marco