Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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:
Regards,
MB
Not sure.
whether Resident will Load the data from path specified QVD.
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.
I suggest you to open this thread in Qlik Sense forum 🙂
S.
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;
Please try to not crosposting your issues invalid path error
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:
Regards,
MB