topic Re: Joining QVD Files in QlikView

Joining QVD Files

Fri, 03 Jan 2014 10:53:22 GMT

Can we Join QVD files ?

My understanding is,

- In report level, if the column names are same, it gets automatically joined

- And While preparing QVD's, we can able to join many tables and prepare as a QVD.

After creating QVD files, can we join the columns ? (Not Report Level)

Regards,

Praveen

Re: Joining QVD Files

Anonymous — Fri, 03 Jan 2014 10:59:13 GMT

Yes , you an creating staging applications , where you can fetch data from datasource or previously built qvds and join them,

now you can create new qvd after joining two qvds:

example

Table:

Load customer, part_id,sale

from sale.qvd;

left join

load part_id,part_name

from part.qvd;

left join

load customer,customer_name

from customer_table.qvd;

store Table inot Sales_data.qvd;

Hope this helps.

Regards

Nitin

Re: Joining QVD Files

Fri, 03 Jan 2014 11:07:08 GMT

Thanks Nitin

Re: Joining QVD Files

walterlh — Fri, 03 Jan 2014 11:37:11 GMT

Indique que la pregunta se ha respondido.

Re: Joining QVD Files

Anonymous — Fri, 03 Jan 2014 11:39:03 GMT

Claim your question has been answered

Re: Joining QVD Files

varunqvmm — Mon, 30 Dec 2019 14:56:42 GMT

RegionMain:

LOAD RegionID ,
Continent,
Country
from [D:\QlikView\QVDS stored\Region.qvd](qvd);
Left Join (RegionMain)
LOAD
ProductID,
RegionID,
TimeID,
SupplierID,
Quantity,
DefectPercentage
from [D:\QlikView\QVDS stored\SupplierQuantity.qvd] (qvd);

STORE RegionMain into [D:\QlikView\QVDS stored\RegionMain.qvd];

I tried to join the following QVDs but a script error is thrown saying that RegionMain table is not found.Can anyone give a solution on this