Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create and select QVD from the same QVW

Hi,

I create several QVDs from ORA, MS SQL. I need to create another QVD from these QVDs with left join in the same load. I get error unable to find QVD when I create my final QVD in the same load.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Moving left join after the data connection worked fine

OLEDB CONNECT32 TO Data Source1;

orders:

load aa, ab , ac;

sql select aa, ab, ac

from abc;

OLEDB CONNECT32 TO Data Source2;

left join

sql select aa, ad , ae

from dbe;

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Provide your script or some more information..

Anonymous
Not applicable
Author

My issue is that I want to left join two tables from two different data sources code one from below gave me errors so I created QVDs to left join and that gives me errors in the same reload

Code1-----left join on the tables

OLEDB CONNECT32 TO Data Source1

orders:

load aa, ab , ac;

sql select aa, ab, ac

from abc;

left join (orders)

OLEDB CONNECT32 TO Data Source2

Orderlookup:

sql select aa, ad , ae

from dbe;

Code2-----left join on the QVD

OLEDB CONNECT32 TO Data Source1

orders:

load aa, ab , ac;

sql select aa, ab, ac

from abc;

STORE orders INTO $(vDataFolderHb)orders_$(vDate).QVD;

OLEDB CONNECT32 TO Data Source2

Orderlookup:

sql select aa, ad , ae

from dbe;

STORE Orderlookup INTO $(vDataFolderHb)Orderlookup_$(vDate).QVD;

Final:

LOAD *

FROM

$(vDataFolderHb)orders_$(vDate).QVD(qvd);

left join(orders)

LOAD * from $(vDataFolderHb)Orderlookup_$(vDate).QVD (qvd);

STORE Final INTO $(vDataFolder)Final_$(vDate).QVD;

------------Error unable to find order although I see QVD created in the same reload. I sure can create one qvw to create qvds and another to left join but would prefare to do everything in one qvw.

Anonymous
Not applicable
Author

Moving left join after the data connection worked fine

OLEDB CONNECT32 TO Data Source1;

orders:

load aa, ab , ac;

sql select aa, ab, ac

from abc;

OLEDB CONNECT32 TO Data Source2;

left join

sql select aa, ad , ae

from dbe;