Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Joining QVD Files

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

Thanks Nitin

walterlh
Creator II
Creator II

Indique que la pregunta se ha respondido.

Anonymous
Not applicable
Author

Claim your question has been answered

varunqvmm
Contributor III
Contributor III

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