4 Replies Latest reply: Jan 9, 2015 4:27 AM by Prince Anand RSS

    Copy Columns from one qvd to another qvd

    sai v

      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

        • Re: Copy Columns from one qvd to another qvd
          Felix Snijders

          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.

          • Re: Copy Columns from one qvd to another qvd
            Jonathan Dienst

            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

            • Re: Copy Columns from one qvd to another qvd
              neetha P

              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.

              • 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