Comparing multiple files to find the rows deleted and rows added

[sonarupasinha]

I have to create a report over a period of time where i have an initial set and every month a new file will be shared where soem rows would be dleetd and some new will be added. How can i create a report of how many rows got added, which got deleted and also update the base file to mark the rows deleted

[Blake_D]

Do the rows have to be deleted or can the be categorized as no longer in use?

I ask because if you have your original set with a "Month" selection field. Then, you add 3 check box fields "Original", "Removed", and "New". Or, you could make 1-2 single select fields with those options. You then could create a report based on different views with filters based on those fields and that way you would not lose the original data, while representing those changes.