topic Re: Create and select QVD from the same QVW in QlikView

Create and select QVD from the same QVW

Anonymous — Thu, 19 Feb 2015 20:28:17 GMT

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.

Re: Create and select QVD from the same QVW

MK_QSL — Thu, 19 Feb 2015 20:41:45 GMT

Provide your script or some more information..

Re: Create and select QVD from the same QVW

Anonymous — Fri, 20 Feb 2015 14:35:32 GMT

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.

Re: Create and select QVD from the same QVW

Anonymous — Fri, 20 Feb 2015 17:10:32 GMT

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;