Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HEY I AM HAVING PROBLEMS WITH THE FOLLOWING JOIN
Inv_Sales_Temp:
LOAD
IVCOST,
IV,
CURRENCY ,
FROM [lib://clinton/InvoiceItems.qvd] (qvd);
LEFT JOIN (Inv_Sales_Temp)
LOAD
CUST,
CUSTNAME,
COUNTRY,
CURRENCY
FROM [lib://clinton/customers.qvd](qvd);
LEFT Join (Inv_Sales_Temp)
LOAD
CUST,
COST
FROM [lib://clinton/Trans.qvd]
(qvd);
I ATTACHED THE ERROR MESSAGE I GOT.
Where did you attach your error message?
Can't see the attached error message, but maybe you just need to remove the comma after CURRENCY in your first LOAD (no comma after the last field loaded).
Hi Jhonatan,
You are trying to left join the CUST and COST fields with the Inv_Sales_Temp table. But there is no such filed names exist in Inv_Sales_Temp. You need a key field, so that left join will work. You can use alias names to left join the table.
Example:
Cust as IVCost.
But you need to explain what is the error and what you are trying to achieve. It will be helpful to give you the solution.
What is the error ??
Invalid path