Create and select QVD from the same QVW

[Anonymous]

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.

[MK_QSL]

Provide your script or some more information..

[Anonymous]

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 · Accepted solution]

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;