Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: JOIN QUESTION

Where did you attach your error message?

MVP
MVP

Re: JOIN QUESTION

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

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
Honored Contributor III

Re: JOIN QUESTION

What is the error ??

Not applicable

Re: JOIN QUESTION

Invalid path