Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
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