LINK/JOIN TWO qvd FILES Emulate SQL

[BrianDH]

I have a fact table (F_Payments.QVD) and a diminution table (Payment_HNDL_DESC.QVD)

How can I emulate the below sql in Qlik?

SQL Example:

(SELECT DESCR FROM PS_PYMNT_HNDL_TBL WHERE PS_PYMNT_HNDL_TBL.PYMNT_HANDLING_CD = PS_PYMNT_VCHR_XREF.PYMNT_HANDLING_CD) X_PYMNT_HANDLING_DESC

Thanks

[dplr-rn · Accepted solution]

it would be something like below

table1:

load

 column1,

column2

from abc.qvd;

join (table1)

load

column1,

column3

from xyz.qvd;

see below for details

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...