2 Replies Latest reply: Nov 14, 2011 5:33 AM by Krishnaroopa Senthilkumar RSS

    Data Reduction when loading from QVD

    Krishnaroopa Senthilkumar

      Hi

       

      I have my data loaded into a QVD file and then in the QVW.

       

      I tried to use initial data reduction using section access in the QVW file.

       

      When i take data from SQL, it is working.

      But when loaded from QVD, it is not working.. Why ?

       

      Thanks

      KRS

        • Data Reduction when loading from QVD
          Sunil Chauhan

          can you please share sample

            • Re: Data Reduction when loading from QVD
              Krishnaroopa Senthilkumar

              I work in Personal Edition. The QVW file may not work. I will share the script block.

               

               

               

              Section Access;

              LOAD * INLINE [

                  ACCESS, USERID, PASSWORD,CLIENTID

                  ADMIN, USER1, PWD1, 14

              ];

                   

               

              Section Application;

               

              ANLShipmentsTemp:

              LOAD DBSource,

                  DBSourceID,

                  ClientID as CLIENTID,

               

              ShipDate,

               

              Amount,

                      Distance,

                  PieceCount;

              Load * from VWBigPicture.QVD (qvd);

               

              ANLShipments:

              NoConcatenate LOAD *

              Resident ANLShipmentsTemp

              order by ShipDate ASC;

               

              Drop table ANLShipmentsTemp;

               

               

               

              Here, I want the data to be sorted by shipdate, hence the temp loading. What is needed is only rows with clientid 14 should be shown to the user1. That is not happening!!

               

               

               

              Regards

               

              KRS