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.
Are you meaning grouping the data by the 5 cols Client-Contractor-Distribution Center-Service Level-Alert Value-Status?
for grouping data have a look here:
In case of our understanding from above is correct we can also provide an effort reducing the effort for constructing the 5 col group keys. So let us know
extended to the 5 cols you have an option for doing grouping without LINQ
otherwise set up an LINQ or LINQ Hybrid (combined with essential activities) approach
Hi @ppr , Thanks for the quick response.
However, I don’t really understand the guide you have posted.
I am just a beginner at RPA and UiPath.
And I have never even heard of LINQ.
But from what I could figure out reading the example, the grouping is being used to group by key columns and then the other columns are being aggregated.
My problem is that I don’t need an aggregation.
I need 5 random records per 6 key column group in the as is state as individual records.