Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
ex:
u have like
file1.qvw;
file2.qvw;
load file1.qvw through binary into file2.1vw;
binary filename.qvw;
file2.qvw;
Thanks for quick Response ..,.,.
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
hi,
how to write the syntax for this please guide me
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
Thanks for giving me detailed information hope this is my solution i am going to work out nw