JOINS IN QV

[#1]

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]

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.

[#3]

Thanks for the reply.