topic Re: Issue with using Resident Load in QlikView

Issue with using Resident Load

QlikNewLearner1 — Fri, 22 Oct 2021 14:31:45 GMT

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!

Re: Issue with using Resident Load

JuanGerardo — Fri, 22 Oct 2021 14:54:11 GMT

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";

Re: Issue with using Resident Load

QlikNewLearner1 — Sat, 23 Oct 2021 13:49:09 GMT

Thanks! Rookie mistake 🙂

Re: Issue with using Resident Load

MarcoWedel — Sun, 24 Oct 2021 17:02:51 GMT

Hi,

please close your thread by accepting an answer as solution.

thanks

Marco