Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Table not found- might be a residente problem?

hey i am trying to run this but keep getting  the error message on the bottom,

INV_TOP_CUSTOMERS:

LOAD

IVCOST,

IV,

IVDATE,

TYPE AS IV_TYPE,

CURRENCY ,

TOTPRICE AS IVA_TOTPRICE,

COMP as INV_COMP,

BONUSFLAG AS IVA_BONUSFLAG

RESIDENT [lib://clinton/InvoiceItems.qvd]

WHERE IVCOST > 10000

ORDER BY IVDATE ASC; 

concatenate (INV_TOP_CUSTOMERS)

LOAD

CUST,

CUSTNAME,

COUNTRY,

CURRENCY

FROM [lib://clinton/customers.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

COST,

CURRENCY,

IV

FROM [lib://clinton/Trans.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

IVDATE,

CURRENCY,

IVNUM as INV_NUMBER,

FINAL AS INV_FINAL

RESIDENT [lib://clinton/Invoices.qvd]

ORDER BY INV_NUMBER ASC;

TABLE NOT FOUND.PNG

1 Solution

Accepted Solutions
miguelbraga
Valued Contributor III

Re: Table not found- might be a residente problem?

Hi Jhonatan,

You can't use resident load on a qvd file. To use Resident you must call an already created table. Please check my document about the different types of Load:

Types of Load into QlikView

Regards,

MB

6 Replies
balrajahlawat
Esteemed Contributor

Re: Table not found- might be a residente problem?

Not sure.

whether Resident will Load the data from path specified QVD.

Re: Table not found- might be a residente problem?

When you use the RESIDENT keyword you can only reference a table that you already loaded, not an external source. If you want to load data from the qvd file then use FROM instead.


talk is cheap, supply exceeds demand
simone_spanio
Valued Contributor

Re: Table not found- might be a residente problem?

I suggest you to open this thread in Qlik Sense forum :-)

S.

MVP
MVP

Re: Table not found- might be a residente problem?

Hi,

I think the issue is with the ORder by remove order by and try .

INV_TOP_CUSTOMERS:

LOAD

*

ORDER BY IVDATE ASC;

LOAD

IVCOST,

IV,

IVDATE,

TYPE AS IV_TYPE,

CURRENCY ,

TOTPRICE AS IVA_TOTPRICE,

COMP as INV_COMP,

BONUSFLAG AS IVA_BONUSFLAG

RESIDENT [lib://clinton/InvoiceItems.qvd]

WHERE IVCOST > 10000;

Employee
Employee

Re: Table not found- might be a residente problem?

Please try to not crosposting your issues invalid path error

miguelbraga
Valued Contributor III

Re: Table not found- might be a residente problem?

Hi Jhonatan,

You can't use resident load on a qvd file. To use Resident you must call an already created table. Please check my document about the different types of Load:

Types of Load into QlikView

Regards,

MB

Community Browser