I have a revenue file that I call baseline, and I want to compare our revenue file as of today and identify all changes.
All columns are the same in both tables, and there is a unique id which can be used to compare rows between both tables.
I’m looking for guidance on the best way to start this model. Do I maintain two separate tables, or do I add a column to Baseline called Baseline and a column to current file call current and then append the table into one, or do you recommend something else.
Each tables have about 30 columns, and I’m mainly looking to compare about 10 of these columns, identifying changes, in values, dates etc…
I’m sure someone must have done this before, and I’m just looking for the best way to start this.