I am working on developing a system health check tool to validate that 4 different systems are in sync. To do that, I need to create a sample dataset of random N number of records for every unique group/key/combination from a main data set everyday. All 4 systems will be checked for records from this sample dataset and any differences will be highlighted using conditional formatting.
For example, there will be a report in excel (main data set) with the following fields (and some more) and thousands of rows. Let’s say I want 5 records for each unique combination (group) of the fields [Client-Contractor-Distribution Center-Service Level-Alert Value-Status]. Reference Number is the column with unique ID’s for which we need the 5 records.
I need help with creating a datatable with the above criteria.