Scenario

[deepakqlikview_123]

Hi All,

I want to merge 3 QVW file into one QVW file.

But it seems data model is too complex and there is data loss.

Shall we perform conditional binary load to call one qvw file at a time in resulting QVW file if so can you please suggest hot to do that.

Thanks,

Deepak

[Gysbert_Wassenaar]

You can use only one binary load statement in the script and it must be the first line. That means you can't use it conditionally. If you want to merge three files with binary loads you need to chain them. Document 2 binary loads the data from document 1, then document 3 binary loads the data from document 2. Etc..etc...

[SunilChauhan]

Ya, i am agree with above post but

you can do document chaining

i.e one qlikview into another  into another

1->2->3

you need to take care of synthetic and circular loops.

may be you need to take resident to resolve this problems

hope this helps

[its_anandrjs]

It is better idea for document chaining from one binary to another and into another. But i believe if you use the QVD which is from the rest of the qvws and by this you have very convince to add the QVD into the model. By this practice you check your model step by step by adding the QVD from the qvw and you can find the synthetic keys and the loops also if created and you can sort out there also.

If data is not huge then document chaining is also a good approach.

[Greg_Williams]

Have you considered parsing and placing the data into QVD files. Take one QVW file at a time to study it's data structure. Are there things in common? Perhaps you can place these "things in common" in a QVD file.

Syntax in QV Script: Store <table name> into <file name>.qvd;

QVD files can contain data from different data sources. The QVD files can then be shared amongst different QVW applications.

Just a thought.

* You can only call a binary load 1 x in the QV edit script.