Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
Creator II

LINK/JOIN TWO qvd FILES Emulate SQL

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

Labels (2)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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...

View solution in original post

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

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...