1 Reply Latest reply: Mar 26, 2018 10:33 AM by Steven Taschereau RSS

    Simplify a table

    Steven Taschereau

      Hi.  I should lose points for asking this, it's such a simple question, but I keep getting a load error.

       

      I have a table Table1 like:

      column_1column_2

      A

      AA
      ABB
      ACC
      BDD
      BEE
      BFF

       

      I want to create the following Table2:

      column_acolumn_b
      AAA,BB,CC
      BDD,EE,FF

       

      Table2:

      load distinct column_1 as column_a,

      concat(column_2,',') as column_b

      resident Table1;

       

      The above doesn't work. What should I be using?