1 Reply Latest reply on Dec 2, 2019 10:24 AM by Nico Heinze

    Grouping Column values Based on Group ID

    Rajat Agarwal New Member

      Hello Friends,

       

      I have a question regarding grouping of Column values based on the Group Id

       

      Source data is shown below:

       

      C_ID
      Group_ID
      C1G1
      C2G1
      C3G1
      C4G1
      G5G1
      G6G1

       

      Target should be like:

      C_ID
      GROUP_IDNEW PORT
      C1G1C2|C3|C4|C5|C6
      C2G1C3|C4|C5|C6
      C3G1C4|C5|C6
      C4G1C5|C6
      C5G1C6
      C6G1NULL

       

      Please help me in resolving this query?