Hello - I have a lot of saved csv files of open sales orders in a folder that I would like to see the incremental additions and deletions from the previous file.
For example, I can group the total open orders of each file easily enough:
8/1/20 Open Orders: 1,000
9/1/20 Open Orders: 900
10/1/20 Open Orders: 950
10/2/20 Open Orders: 970
10/3/20 Open Orders: 900
However, what I desire to see is:
9/1/20 Open Orders: 900 Change from 8/1/20 100 additions, 200 deletions, Net Change -100
10/1/20 Open Orders: 950 Change from 9/1/20 100 additions, 50 deletions, Net Change +50
10/2/20 Open Orders: 970 Change from 10/1/20 20 additions, 0 deletions, Net Change +20
10/3/20 Open Orders: 900 Change from 10/2/20 30 additions, 100 deletions, Net Change -70
I figured I could easily enough do some various merges to determine the changes from one file to a previous file. However I don't know of an efficient way to get perform a process to determine the changes for each file's previous file?
Thoughts?
For example, I can group the total open orders of each file easily enough:
8/1/20 Open Orders: 1,000
9/1/20 Open Orders: 900
10/1/20 Open Orders: 950
10/2/20 Open Orders: 970
10/3/20 Open Orders: 900
However, what I desire to see is:
9/1/20 Open Orders: 900 Change from 8/1/20 100 additions, 200 deletions, Net Change -100
10/1/20 Open Orders: 950 Change from 9/1/20 100 additions, 50 deletions, Net Change +50
10/2/20 Open Orders: 970 Change from 10/1/20 20 additions, 0 deletions, Net Change +20
10/3/20 Open Orders: 900 Change from 10/2/20 30 additions, 100 deletions, Net Change -70
I figured I could easily enough do some various merges to determine the changes from one file to a previous file. However I don't know of an efficient way to get perform a process to determine the changes for each file's previous file?
Thoughts?
