5 Replies Latest reply: Sep 10, 2012 6:55 AM by Stefan Kunte RSS

    join/ removing specific combinations

    Stefan Kunte

      Dear users,

       

      I joined two completely different tables which results in a new table with every possible combination, like this:

       

       

      column acolumn b
      aa
      ab
      ac
      ad
      ae
      ba
      bb
      bc
      bd
      be

      ...

      The problem is that I have 2 times the combination a (col a)  and b (col b) and vice versa b (col a) and a (col b). For data export purposes I need only one of these combinations, is there any possibility to cut the "doublets"?

       

      Best

      Stefan