Removal with paired data

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

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store