topic Method to merge two qvw apps. in QlikView

Method to merge two qvw apps.

Fri, 28 Nov 2014 09:08:40 GMT

Hi,

Is there any recommended method or approach to merge two qvw files into a single qvw file?

For example, I need to merge two apps Example1.qvw and Example2.qvw in a single app Example1.qvw.

(I am only aware of copying/pasting script and obejcts)

-Abhishek.

Re: Method to merge two qvw apps.

jpenuliar — Fri, 28 Nov 2014 09:11:10 GMT

Try looking at Binary Loads, where you load the data model of the first file to the second.

Re: Method to merge two qvw apps.

PrashantSangle — Fri, 28 Nov 2014 09:12:34 GMT

Hi,

You can use Binary load.

Regards

Re: Method to merge two qvw apps.

amit_saini — Fri, 28 Nov 2014 09:13:16 GMT

Hi,

Binary load is used to share the entire dtamodel between 2 QVWs. Basically, the datamodel of one QVW (Q1) is copied from RAM to disk in 0 and 1 form, for another QVW (Q2). Thus Q2 inherits entire data of Q1.

e.g. if you have a base QVW where the common metrices are designed and you want to enhance this to build more business specific dashboards, Binary load is a good option.

Also, if you want to do incremental load, the loading of high volume historical data can be done by binary mothod, to utilize its speed.

Point to be noted here is: Binary has tobe the first statement of the script.

e.g.

Binary order.qvw;

Binary c:\order.qvw;

To do a binary load use the QlikView File button in the Edit Script dialog.

Note that the resulting script code that is placed as the first line of your load script must stay the very first line. Also, you can not chose to only load some of the data model - it has to be the whole lot. You can however DROP some tables after the Binary Load has completed.

Thanks,

Re: Method to merge two qvw apps.

Fri, 28 Nov 2014 09:19:42 GMT

Yes. If your both Example1 and Example2 qvw are stored in seperate qvd. Then, you can load that QVD's into one QVW.

See below Example.

OpenSo:

LOAD * FROM OpenSalesOrder.QVD (qvd);

CurrentHistory:

LOAD * From SalesHistoryCurrent.QVD (qvd);

CSR_OpenSo:

LOAD

SoPlantWERKS AS CSR_PlantCode,

SoPlant as CSR_Plant,

SoMonth as CSR_Month,

SoNoVBELN as CSR_SoNo,

SoSoldToCode AS CSR_SoldToCode,

SoSoldToName as CSR_SoldToName,

SoShipToCode as CSR_ShipToCode,

SoShipToName as CSR_ShipToName

Resident OpenSo Where SoLiStatus = 'A';

STORE CSR_OpenSo into CSR_OpenSo.qvd;

drop Table CSR_OpenSo;

drop Table OpenSo;

CSR_CurrentHistory:

LOAD

BillingPlantWERKS AS CSR_PlantCode,

BillingPlant as CSR_Plant,

Month(BillingRequestedDate) as CSR_Month,

BillingSoNoAUBEL as CSR_SoNo,

BillingSoldToCode AS CSR_SoldToCode,

BillingSoldToName as CSR_SoldToName,

BillingShipToCode as CSR_ShipToCode,

BillingShipToName as CSR_ShipToName

Resident CurrentHistory;

STORE CSR_CurrentHistory into CSR_CurrentHistory.qvd;

drop Table CSR_CurrentHistory;

drop Table CurrentHistory;

Regards

Amol Khochare

Re: Method to merge two qvw apps.

Fri, 28 Nov 2014 18:03:34 GMT

Hi,

1. select the first qvw file in secondary qvw file using edit escipt > Qlikview File > "select the file" (Binary wolud be placed in first statement of edit script.)

2. now load the file, i.e., same structure it would be concatenated with first one.

I hope this will help you. Please check..

@Sub2u