RaqForum 25 No.
219 View  • 
     ...

4.10 Sort data in each group

 
spl-cookbook(224)

We have data as follows:

Class Name Math
1 Tom 85
2 John 92
2 Joan 86
1 Rocky 95
2 Ham 92
1 Kate 83
1 Rose 95
2 Nomy 78
1 Neil 91
2 Jack 84
1 Joe 98

The task is to group data by class and then sort data in each group by score in descending order:

SPL script:

A
1 =T(“score.xlsx”).group(Class).(~.sort@z(Math)).conj()

Execution result:

Class Name Math
1 Joe 98
1 Rocky 95
1 Rose 95
1 Neil 91
1 Tom 85
1 Kate 83
2 John 92
2 Ham 92
2 Joan 86
2 Jack 84
2 Nomy 78

 

spl-cookbook(224)
 
 •  219 View  •