Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

JOIN QUESTION

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.

5 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Where did you attach your error message?

swuehl
MVP
MVP

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).

tamilarasu
Champion
Champion

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.

sujeetsingh
Master III
Master III

What is the error ??

Not applicable
Author

Invalid path