Having historical snapshot data combined into a list. Struggling to determine only the serial numbers that changed for each site name.
Sample input data:
Expected Output:
site name serial
a 3
Sample input data:
| Sitename | Serial | Date |
| a | 1 | 2020/01/01 |
| a | 2 | 2020/01/01 |
| a | 3 | 2020/01/01 |
| b | 4 | 2020/01/01 |
| b | 5 | 2020/01/01 |
| a | 3 | 2020/02/02 |
| a | 2 | 2020/02/02 |
| a | 1 | 2020/02/02 |
| b | 4 | 2020/02/02 |
| b | 5 | 2020/02/02 |
| a | 1 | 2020/01/01 |
| a | 2 | 2020/01/01 |
| a | 9 | 2020/01/01 |
| b | 4 | 2020/01/01 |
| b | 5 | 2020/01/01 |
Expected Output:
site name serial
a 3
