If i want to load data from Different QVW files to one QVW file by using binary load but the problem is in script only one binaryload will be allowed then how to fetch the data from other QVW's data?

[#1]

Hi Qlikview professionals.

could u plz help me.by providing script

If i want to load data from Different QVW files to one QVW file by using binary load but the problem is, in script only one binary load will be allowed then how to fetch the data from other QVW's data to target QVW?

[sunny_talwar]

May be use multiple qvd loads instead of multiple qvw loads. or may be do a single qvw load and multiple qvd loads after that.

[evan_kurowski]

Hello Narayana,

You can use the QVW Juicer, to squeeze all the tables from a single .QVW, and it will generate a load script for a series of QVD's.  You could extract QVDs from multiple apps and just paste each subsequent load script into the unifying application.  Evolution of a QVD Extracting Application (the .QVW Juicer)

Also, if you detect you are going to have a lot of field names that are reused between more than one .QVW, turn on the qualify option by

qualify *;

Then once all the tables are loaded, you won't risk a giant set of synthetic keys (which would probably crash the app).  Identify the appropriate key fields between .QVW, and unqualify them in a controlled manner.

[qlikviewwizard]

Hi,

For example you have 3 qvws like QlikviewFile1.qvw,QlikviewFile2.qvw,QlikviewFile3.qvw.

You wanted to load into one qvw QlikviewFile4.qvw.

QlikviewFile4.qvw as follows:

Binary QlikviewFile1.qvw;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Paste the QlikviewFile2.qvw script

Paste the QlikviewFile3.qvw script

Hope this will help you.

[Anonymous]

Hi Narayana,

use Multiple QVDs instead of Multiple QVWs.

Please check below link:

Re: QlikView Project Tiers/Layers