3 Replies Latest reply on Oct 8, 2015 10:34 AM by Steven Hawkins

    'concat' when no of rows is not fixed

    Prashanthi Kairuppala Novice

      Hi,

       

      I am creating a virtual table by doing an inner join on multiple oracle source tables.

      One of the tables has multiple rows based on one id. And the number of rows is not fixed.

      I need to con-cat these multiple columns based on id and expose as one column. I am able to do a two column from the same row, but if the number of rows is not fixed, can i do it in virtual tables or do i need to write procedures?

       

      Sample table -

       

      valueid
      value11
      value21
      value31
      value12
      value22
      value13
      value23
      value33

       

      i need the output to be

       

      valueid
      value1,vaue2,value31
      value1,value22
      value1,vaue2,value33

       

      Thanks in advance,

      Prashanthi