Table not found- might be a residente problem?

[#1]

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;

[Anonymous]

Not sure.

whether Resident will Load the data from path specified QVD.

[Gysbert_Wassenaar]

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.

[simospa]

I suggest you to open this thread in Qlik Sense forum 🙂

S.

[jagan]

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;

[Clever_Anjos]

Please try to not crosposting your issues invalid path error

[miguelbraga · Accepted solution]

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