Removal with paired data
Jul 21, 2021
Example
There is an Excel file Book1.xlsx, and part of the data is as follows:
Delete the number of rows that match the id and item and the amount can be offset by the positive and negative values. The result is as follows:
Write SPL script:
A1 Read excel file
A2 Group by id and item, filter out the data whose sum of amount is not 0 in the group, and merge
A3 Export results to result.xlsx