Every month I get a new 'Actives' report containing all active employees and relative information. Occassionally, columns are added or removed from the report. Every month when I get the new report, I would like to create a new table that lists all of the Employee IDs from the previous months table that are not found in the current months table.
I have tried using the EXCEPT function to create a new table, but since the column numbers are not always the same I get an error. I would like the new table to include all columns from the current months table.
Example:
June Actives Table
| Empl ID | Bonus | Program |
| 1 | 10000 | Sales |
| 2 | 5000 | Discretionary |
| 3 | 6500 | Legally Required |
July Actives Table
| Empl ID | Notes | Bonus | Program |
| 4 | | 10000 | Legally Required |
| 2 | | 5000 | Discretionary |
| 3 | | 6500 | Legally Required |
New Table 1:
new table = rows in June Actives Table that are not present in July Actives Table
| Empl ID | Notes | Bonus | Program |
| 1 | | 10000 | Sales |
Side note: I am hoping that this will make it easy for me to combine the "New Table" with the "July Actives Table" and note any employment changes. Eventually, I would like to have a table that keeps a running list of any changes, something like this:
New Table 2: updated July Actives
new table 2 = rows in June Actives Table that are not present in July Actives Table & includes all records from July Actives Table
| Empl ID | Notes | Bonus | Program |
| 1 | Removed | 10000 | Sales |
| 2 | | 5000 | Discretionary |
| 3 | | 6500 | Legally Required |
| 4 | Added | 10000 | Legally Required |
Any help would be greatly appreciated. Please let me know if I need to clarify anything. Thank you very much!
