14 Replies Latest reply: Apr 28, 2014 5:14 PM by Manish Kachhia RSS

    Compare data of different tables using text object

    Sandeep Jeereddy

      I need to find out the matching distinct values in col1 of table 1 and table2. I need the result in a text object.Also, if possible I do not wish to create any additional tables in the data model. Can anyone help?


      TABLE1:
      LOAD * INLINE [
      COL1, COL2
      A,2
      B,4
      C,5
      D,2
      H,3
      ]
      ;

      TABLE2:
      LOAD * INLINE [
      COL1,COL4
      A,4
      B,4
      A,23
      ]
      ;