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
Comparing multiple files to find the rows deleted and rows added
+11Do 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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.