how to merge two qvw files ..,.,.,.,

[#1]

Hi i am big confusing to how to merge two qvw files as a one application if some buddy going to help please. if need i ll share those files please help me out in this situation

[#2]

Hi,

pls try to write them as 2 separate QVD files

Store table into....

and read them in a new qvw like

Table: noconcatenate

load * from ....qvd1

concatenate(Table)

load * from ....qvd2

or join them...

hth

F.

[#3]

ex:

u have like

file1.qvw;

file2.qvw;

load file1.qvw  through binary into file2.1vw;

binary filename.qvw;

file2.qvw;

[#4]

Thanks for quick Response ..,.,.

[its_anandrjs]

Hi,

There are different ways for this.

1. Create Binary load QVW file into another QVW file two.

2. Create the QVD from the QVW and then load into another QVW file.

3. Use Common QVDs in both and make single QVD if not possible to join or conatenate use QVD there.

Regards

Anand

[#6]

hi,

how to write the syntax for this please guide me

[Anonymous]

Hi,

You can merge two qvw’s in various ways:

1.    Copy the script from first document to second document. Next copy all the sheet objects from first document to second document.

       2.    Binary load first document to second document.

               a. You can only use it as the first statement of a load script.

b. There can only ever be one binary load per .qvw.

ex: Binary C:\Docs\MyFile.qvw;

From there you can then add additional traditional load statements to build on the data model.

              Next copy all the sheet objects from first document to second document.

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

       3.    Copy data model:

                a.Create QVD’s of the tables (exclude tables which exist in second document) in first document.

                b.Use these QVD’s in second document.

                c.Then copy paste the objects to second document if required,

      But you have to check synthetic keys created in second document, so be aware of that.

Regards

Neetha

[#8]

Thanks for giving me detailed information hope this is my solution i am going to work out nw