I need to compare Dataset A to Dataset B and aggregate the reconciliation using the "Name" column from each dataset to illustrate any quantity, month to date PnL, and any other differences between the two datasets.
I can't figure out how to easily compare the two datasets since some Names are repeated (cannot remove duplicates, each name is valid)
I can't figure out how to easily compare the two datasets since some Names are repeated (cannot remove duplicates, each name is valid)
| Dataset A | ||
| Name | quantity | month-to-date PnL |
| John | 98382 | 1665988 |
| John | 72344 | 305961 |
| John | 70455 | -1123862 |
| Paul | 88425 | 604236 |
| Paul | 74451 | 1610242 |
| Paul | 85720 | 988013 |
| Paul | 39964 | 325181 |
| Paul | 54264 | -1192519 |
| Bob | 14633 | -1221182 |
| Bob | 19656 | -1292593 |
| Bob | 82073 | 28946 |
| Bob | 2836 | -1119430 |
| Steve | 40539 | 1541498 |
| Dataset B | ||
| Name | quantity | month-to-date PnL |
| John | 98382 | 1665988 |
| John | 72344 | 305961 |
| John | 70455 | -1123860 |
| Paul | 88500 | 604236 |
| Paul | 85720 | 988013 |
| Paul | 74451 | 1610242 |
| Paul | 54264 | -1192519 |
| Paul | 39964 | 325181 |
| Frank | 88551 | 89421 |
| Bob | 82073 | 28946 |
| Bob | 19656 | -1292593 |
| Bob | 14633 | -1221182 |
| Bob | 2836 | -1119430 |
