9 Replies Latest reply on Aug 10, 2017 10:47 AM by Hari Chandan Reddy Maryada

    Group and concat

    Nivedha Satyamoorthi

      hi everyone, I am trying to print out long format to wide with group by. The attached example explains what I am looking for. A single student can have more then 1 educators. For example, John has two educators and thereby two comments. I need John's row to be grouped as one single row and the comments concatenated. Is this possible?

       

             

      StudentStudent NameEducatorCommentACommentB
      1JohnAprilGoodExcellent
      1JohnmaryFairAvg
      2JamesAbrahamGood workAvg work
      3GaryAdamsGood workNot bad
      3GaryAbrahamFairExcellent
      3GaryMaryGood

      Excellent

       

       

      StudentStudent NameEducator1 CommentsEducator2 Comments
      1JohnGood , FairExcellent, Avg
      2JamesGood workAvg work
      3GaryGood work, Fair, GoodNot bad, Excellent, Excellent