RaqForum 22 No.
1 Reply  •  344 View  • 
     ...

Remove duplicate and summary columns when merging

 

There is an Excel file of math score math.xlsx, and the data is as follows:

..

There is an Excel file of English score english.xlsx, and the data is as follows:

..

The task is to calculate the total score of math and English for each student. The results are as follows:

..

Write the SPL script:

A

1

=file("math.xlsx").xlsimport@t()

2

=file("english.xlsx").xlsimport@t()

3

=[A1,A2].conj()

4

=A3.groups(id,name;sum(score):score)

5

=file("total.xlsx").xlsexport@t(A4)

A1 and A2 Read the data of math.xlsx and english.xlsx respectively

A3 Combine the data of math and English scores.

A4 Group the data by id and name, and calculate the total score of English and math for each student.

A5 Export results to total.xlsx 

 

 


 
 •  344 View  •