topic Re: JOIN QUESTION in QlikView

JOIN QUESTION

Tue, 03 Nov 2015 12:50:07 GMT

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.

Re: JOIN QUESTION

Peter_Cammaert — Tue, 03 Nov 2015 16:12:59 GMT

Where did you attach your error message?

Re: JOIN QUESTION

swuehl — Tue, 03 Nov 2015 16:13:13 GMT

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

Re: JOIN QUESTION

tamilarasu — Wed, 04 Nov 2015 01:54:27 GMT

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.

Re: JOIN QUESTION

sujeetsingh — Wed, 04 Nov 2015 08:35:36 GMT

What is the error ??

Re: JOIN QUESTION

Wed, 04 Nov 2015 09:32:05 GMT

Invalid path