Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. 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

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