Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
gupta_n8
Specialist II
Specialist II

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
gupta_n8
Specialist II
Specialist II

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

Not applicable
Author

Thanks Nitin

walterlh
Creator II
Creator II

Indique que la pregunta se ha respondido.

gupta_n8
Specialist II
Specialist II

Claim your question has been answered

varunqvmm
Contributor II
Contributor II

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