Copy Columns from one qvd to another qvd

[#1]

Hi Team,

Is there a way to copy only few particular columns from a QVD file to another QVD file or a QVW to another QVW.

Thanks,

Sai

[#2]

Hi,

not that I know of, you can copy a complete QVW with the binary load statement or generate another QVD from within a QVW and store the new QVD with the columns you add.

hth

F.

[jonathandienst]

Hi

To copy selected fields from a QVD, create a QVW that loads only those fields and then saves the resulting table to the new QVD. If you need a subset of the rows, use a where clause when loading the source.

Its more complicated to copy selected information from a QVW - you can binary load the source QVD and then drop tables and or fields in the script. If you need a subset of the rows, use a resident load with a where clause and drop the original table.

HTH

Jonathan

[Anonymous]

Hi,

Try below to Copy columns from one QVD to another QVD, List field names you want to copy in load statement:

Data:
LOAD
Customer,
[Sales Order ID],
ShipDate,
Product,
Sales,
Quantity
FROM QVD\Main.qvd(qvd);


STORE Data into Data.qvd;
DROP Table Data;

Use Binary Load to copy QVW to another QVW:

  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.

[#5]

Dear S V,

Simply load like this:-

Student:

load Name,RollNo;

load Name,RollNo,

Class,

Marks,

Total_Marks,

F_Name

from Student.qvd;

Store Student into Result.qvd(qvd);

Thanks & Regards

Prince Anand