topic Re: JOINS IN QV in QlikView

Re: JOINS IN QV

Wed, 27 Jan 2010 13:31:47 GMT

Hi,

I am new to QV, only started yesterday.

I need to join two tables. I get my data from two CSV files: SALES_TRANSACTION_DETAIL.csv and CATEGORY.csv

This is the code that I would use in SQL:

---------------------------------------------------

SELECT TD_PRODUCTCODE, TD_DESCRIPTION, CT_NAME

FROM SALES_TRANSACTION_DETAIL

LEFT OUTER JOIN CATEGORY

ON CT_CODE = TD_CATEGORY_ID3

---------------------------------------------------

How would I join the two tables in QV.

Please, any help will be appreciated.

Miguel_Angel_Baeyens — Wed, 27 Jan 2010 13:56:47 GMT

Hello,

When loading your table in QlikView, name key fields the same, i. e.: in this case

LOAD ... CT_CODE AS PK_EXAMPLE ... LEFT JOIN LOAD ... TD_CATEGORY_ID3 AS PK_EXAMPLE ...

You will get one unique table with values joined by that field.

Hope this helps.

Wed, 27 Jan 2010 14:08:08 GMT

Thanks for the reply.