Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikNewLearner1
Contributor
Contributor

Issue with using Resident Load

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!

Labels (1)
1 Solution

Accepted Solutions
JuanGerardo
Partner - Specialist
Partner - Specialist

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

View solution in original post

3 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

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
Contributor
Contributor
Author

Thanks! Rookie mistake 🙂

MarcoWedel

Hi,

please close your thread by accepting an answer as solution.

thanks

Marco