Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Copy Columns from one qvd to another qvd

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

Tags (1)
4 Replies
Not applicable

Re: Copy Columns from one qvd to another qvd

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.

jontydkpi
Not applicable

Re: Copy Columns from one qvd to another qvd

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
neetha_p
Not applicable

Re: Copy Columns from one qvd to another qvd

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.

Not applicable

Re: Copy Columns from one qvd to another qvd

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