Does anyone have any suggestions on how to compare a view with an excel spreadsheet and note the differences either in a another view or some other way? Or perhaps compare 2 similiar views with each other and note the differences in a 3rd view?
Columns in both the Excel spreadsheet and the view to be compared with would match as far as names.
The reason for this is as follows:
We have a report that comes down from our mainframe each month showing usernames and the applications and transactions that they have. I open this report in monarch, apply a model, then export it to a table and save it as an excel spreadsheet.
Users request transactions and applications using a Notes database which goes through an approval process. I want to make sure that what the users are approved for matches what they have in the downloaded report.
Any suggestions would be appreciated.