2 Replies Latest reply: May 11, 2012 10:02 AM by Jagan Nalla RSS

    Join of table

      Hello,

       

       

      I have two tables on is master table and contains so many columns and second table has same data but i want to know the records which is not present in the second table but i need to know that record like

       

      ex:

       

      MasterTable1:

       

      vtc,sdc,blk

      2,1,2    

      3,1,3

      4,2,4

      5,2,5

       

      DataTable2:

       

      vtc,sdc,blk

      2,1,2    

      3,1,3

       

      in second table last 2 record which is present in Mastertable but not in Datatable i want to get only those 2 records details like

       

      4,2,4

      5,2,5

       

       

      like ways i have 5000 records, any one provide help for this

       

       

       

      SRS

        • Join of table
          Jagan Nalla

          Hello,

           

          Try this code. Hope it helps you.

           

          DataTable2:

          LOAD *,F1&F2&F3 as key;

          LOAD * INLINE [

              F1, F2, F3

              2, 1, 2

              3, 1, 3

          ];

           

          MasterTable1:

          LOAD *,1 as CountValue

          Where Not Exists(key,F1&F2&F3) ;

          LOAD * INLINE [

              F1, F2, F3

              2, 1, 2

              3, 1, 3

              4, 2, 4

              5, 2, 5

          ];

           

          DROP Table DataTable2;

            • Join of table
              Jagan Nalla

              Try this

               

              Data:

              LOAD

              [S NO],

              sdn,

              vtc,

              blk,

              sdc

                  

              FROM

              [C:\Users\Administrator.QLIKVIEW\Downloads\Copy of TData.xlsx]

              (ooxml, embedded labels, table is Data);

               

               

               

              Main:

              LOAD [S NO],

                   sdn,

                   vtc,

                   blk,

                   sdc,1 as CountValue

              FROM

              [C:\Users\Administrator.QLIKVIEW\Downloads\Copy of TData.xlsx]

              (ooxml, embedded labels, table is Main)

              Where Not Exists([S NO]) ;

               

              DROP Table Data;