We are trying to create controls to achieve a certain outcome.
The control would compare 2 files.
Each file has 10 records
Today, we have created controls that do not do exactly what we want.
Today, we get alerts for each of the discrepancies in the 2 files.
We don’t want this.
We want to be able to compare the 2 files and find all the discrepancies.
We want one report, that lists all the discrepancies.
We want one summary alert to go out.
We would like to, if possible, know how to reference that report so that we can look at it later.