1 Reply Latest reply: Jun 3, 2011 12:03 AM by Erika Jain RSS

    Regarding comparision between two qvds

      Hi Everyone Special,

       

      I have a new problem at which I am stuck at the moment.

       

      A. I have a field called MPN in two  separate qvds- say qvd A and qvd B. MPN holds product number.

      Over the period there are many product which gets cancelled.

      QVD A stores the history and the QVD B stores the current records.

      So there are cases in which MPN has product numbers in QVD A but as the product got cancelled so the MPN field in QVD B won't be having

      any of those product number. The requirement calls them deleted items.

      Now the task is to find how many of such product number got deleted over the period.

       

      Thanks beforehand and I really appreciate your time and effort,

      Bikash

        • Re: Regarding comparision between two qvds

          Plz find the attachment....

          Hope it solves ur purpose...

           

           

           

          if u can't open the file then refer this:

           

          AA:

          LOAD * INLINE [

              MPN

              1

              2

              3

              4

              5

          ];

          BB:

          LOAD * INLINE [

              MPN1

              3

              4

              5

          ];

          CC:

          Load

          MPN1,

          MPN1 as MPN

          resident BB;

          drop table BB;

           

           

           

           

           

           

           

           

           

           

           

           

          In front End:

          To count deleted items:

          =

          count(if(MPN<>MPN1,MPN))

          To find deleted Items:

          =if(MPN<>MPN1,MPN)  in list box.