2 Replies Latest reply: Jul 5, 2011 3:50 AM by amartya.dey RSS

    Data difference in two resident tables

      Hi All,

       

      I am very new to Qlikview. I am facing the following problem in QlikView. The version I am using is Version: 9 SR3

       

      I have 2 tables loaded from QVD.

      1. Market Details

      2. Revenue Details

       

      Common Column Name for this two table is Carrier_No.

       

      I need to find out what are the list of values (of Carrier_No) which are present in Revenue Details but not present in Market Details. After that I need to store the same in another QVD.

       

      It will be very helpful you could please guide me to achieve the solution.

       

      Thanks,

      Amartya

        • Data difference in two resident tables
          Erich Shiino

          Your code would look like this:

          [AFTER YOU LOADED BOTH TABLES....]

           

          noconcatenate

          TEMP:

          Load * resident RevenueDetails;

          left join (RevenueDetails)

          Load *, 1 as flag

          resident MarketDetails;

           

          noconcatenate

          differences:

          Load distinct Carrier_No resident TEMP where flag<>1;

           

          drop table TEMP

          store differences into differences.qvd;

           

          drop table differnces;

            • Data difference in two resident tables

              Hi Erich,

               

              Thanks for your reply. I was not able to follow your answer as I was supposed to meet smone sort of deadline. So, I implemented in my way.

               

              During the load of data from QVD I outer joined 2 tables.

              Revenue_Temp:

              LOAD * FROM Revenue.qvd

              outer join

              LOAD * FROM Market.QVD

               

              Undefined_Carrier:

              LOAD Carrier_No RESIDENT Revenue_Temp

              WHERE NOT EXISTS(Group_No); //Group_No is a clolumn from Market Table which is not there in Revenue Table.

               

              Sorry for replying late. I will definitely check and mark your answer.

               

              Thanks for your reply again,

              Amartya