3 Replies Latest reply: Jan 18, 2016 2:46 AM by Massimo Grossi RSS

    Converting multiple row values into single columns

    Rajesh G

      Hi All,

      I have a requirement here where i need to convert multiple row values into single columns with some special characters

       

      ID   Status

      1      AB

      1      CDEF

      1       GHI

      1       JKLMN

      2       XYZ

      2      UVWX

      2       PR

       

       

      ID Status

      1   AB // CDEF// GHI // JKLMN

      2   XYZ// UVWX // PR

       

      if we use Concat function it will concatenate all the field values . But my requirement is i need '//' also between each field value.

      do we have any other solutions to resolve this issue.

       

       

      Thanks