Discussion Board for collaboration related to QlikView App Development.
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)
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:
Load customer, part_id,sale
store Table inot Sales_data.qvd;
Hope this helps.
View solution in original post
Indique que la pregunta se ha respondido.
Claim your question has been answered
LOAD RegionID ,Continent,Countryfrom [D:\QlikView\QVDS stored\Region.qvd](qvd);Left Join (RegionMain)LOADProductID,RegionID,TimeID,SupplierID,Quantity,DefectPercentagefrom [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