Help

Comparing multiple files to find the rows deleted and rows added

Topic Labels: Importing-Exporting
471 1
cancel
Showing results for 
Search instead for 
Did you mean: 
sonarupasinha
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Blake_D
6 - Interface Innovator
6 - Interface Innovator

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.