Let's say the data looks like:     StudentName  StudentId  Grade  ExamDate    Tom  1  60  2021-04-01    Jerry  2  70  2021-04-01    Tom  1  62  2021-04-07    Jerry  2  55  2021-04-07     And the the result I want looks like:     Formatted    Tom,1:2021-04-01,60;2021-04-07,62    Jerry,2;2021-04-01,70;2021-04-07,55     I want to divide the origin data into groups by key "StudentId", and then merge the contents in each group to make a formatted string  Of course, I can get all the data and write a program in Python or Java to process it.... But it would be better if I can do this only with SPL  I have written a script to group by "StudentId":        transaction StudentId
| stats list(_raw) as rawList by StudentId        But don't know what to do next 
						
					
					... View more