Counting repetitions
Jul 21, 2021
Example
There is an Excel file mat.xlsx, part of the data is as follows:
Count the number of repeated occurrences, and the results are as follows:
Write SPL script:
A1 Read excel file
A2 Summarize the number (key), add a column for the number of repetitions (num)
A3 Export results to result.xlsx