1 Reply Latest reply: Jul 20, 2011 9:16 AM by Roland Kunle RSS

    Measuring the gap between two matching tables

    patrice GARCIA

      Hello

       

      I have two tables:

           Table 1, with columns A, B and C

           and Table 2 with columns A, D and F

       

      These two tables are linked by the field A (same name)

       

      I would like to count the number of rows in the table 1, with column A does not match with table B and ditto for the table 2, the number of rows in the table 2,  with the column A does not match with the table A

       

      thank you

       

      P

        • Measuring the gap between two matching tables

          Hi P,

          you can't count key-fields, in your case column "A". If you need this, create a surrogato key (my fav for this is using the autonumber() - function) and decide wich column A you want to keep. If you need to count both columns A, my suggestion for your code would be similar to this:

          LOAD

               autonumber(A,1) AS A_ID, //  key field for linking the tables

               A as A_1

          From Table1

          ....

          LOAD

               autonumber(A,1) AS A_ID,

               A as A_2

          From Table2

           

          Regards, Roland