Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
When loading your table in QlikView, name key fields the same, i. e.: in this case
You will get one unique table with values joined by that field.LOAD ... CT_CODE AS PK_EXAMPLE ... LEFT JOIN LOAD ... TD_CATEGORY_ID3 AS PK_EXAMPLE ...
Hope this helps.
Thanks for the reply.