4 Replies Latest reply: Feb 4, 2015 7:24 PM by Rob Wunderlich RSS

    Qvd exclude column

    ria Desai

      How to exclude a column from the qvd?

      rather columns....while reloading it into another .qvw

       

      Any example is appreciated

        • Re: Qvd exclude column
          Simone Spanio

          Not sure I understood... what about this:

           

          MyTable:

          SQL SELECT field1, field2, field3 from your_table; //or LOAD... it depends from where you are starting!

           

          STORE MyTable INTO myTable_qvd.qvd;

          DROP MyTable;

           

          //With this you reloaded only 2 columns...

          MyTableReloaded:

          LOAD field1, field3 from myTable_qvd.qvd

          (qvd);

           

          //...and if you want with this statement you overwrite the qvd

          STORE MyTableReloaded INTO myTable_qvd.qvd;

           

          S.

            • Re: Qvd exclude column
              ria Desai

              yeah..in this case i have to mention all the fields i want and remove the ones i dont want.

               

              What if i have 35 fields and want to exclude one.

              Do I have any other way than writing all 34?

                • Re: Qvd exclude column
                  Simone Spanio

                  You can do this lazy boy :-) :

                   

                  MyTable:

                  SQL SELECT field1, field2, field3 from your_table; //or LOAD... it depends from where you are starting!

                   

                  STORE MyTable INTO myTable_qvd.qvd;

                  DROP MyTable;

                   

                  EXIT SCRIPT;

                  //so now you created .qvd.

                  //after this, you can use the button that allows you to open local files (something like tabellar files or table fields, I have no English version) and use the wizard. Then you have the entire list of files, so you can remove what don't you use.

                  //remember to remove or comment the EXIT SCRIPT

                   

                  //With this you reloaded only 2 columns...

                  MyTableReloaded:

                  LOAD field1, field3 from myTable_qvd.qvd

                  (qvd);

                   

                  //...and if you want with this statement you overwrite the qvd

                  STORE MyTableReloaded INTO myTable_qvd.qvd;


                  S.

                  • Re: Qvd exclude column
                    Rob Wunderlich

                    LOAD * FROM x.qvd (qvd);

                    DROP FIELD FieldA, FieldG;

                     

                    -Rob