...

4.4 Sort row-wise data by expression

 
spl-cookbook(224)

Sort score table by total score of math, English and PE in descending order. Below is data in score table:

Class Name Math English PE
1 Tom 85 97 74
2 John 92 80 95
2 Joan 86 67 85
1 Rocky 95 95 75
2 Ham 92 75 53
1 Kate 83 99 50
1 Rose 95 62 81
2 Nomy 78 91 70
1 Neil 91 83 97
2 Jack
1 Joe 98 71 60

SPL script:

A
1 =T(“score.xlsx”)
2 =A1.sort@z(Math+English+PE)

Execution result:

imagepng

spl-cookbook(224)
 
 •  170 View  •