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

Table not found- might be a residente problem?

Wed, 04 Nov 2015 10:06:02 GMT

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,

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;

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

Anonymous — Wed, 04 Nov 2015 10:49:11 GMT

Not sure.

whether Resident will Load the data from path specified QVD.

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

Gysbert_Wassenaar — Wed, 04 Nov 2015 10:50:23 GMT

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.

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

simospa — Wed, 04 Nov 2015 10:50:55 GMT

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

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

jagan — Wed, 04 Nov 2015 10:52:15 GMT

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;

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

Clever_Anjos — Wed, 04 Nov 2015 10:53:40 GMT

Please try to not crosposting your issues invalid path error

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

miguelbraga — Wed, 04 Nov 2015 11:03:58 GMT

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,