Filter DataTable to pull any (Top Or Random) 5 records for each user

Help Studio
, ,
1

Hello,

I have a table with some data and every row as assignee name, I have around 100 records with diff assignees, but I have to pull only any 5 rows for each user from the data table. Kindly help me to filter this scenario,

Thanks in advance.!

SampleData.xlsx (9.4 KB)

2

Hi @ramesh_kola

Have a look on the thread

Regards
Gokul

3

Hi,

How about the following?

img20220321-2
img20220321-2691×475 12.5 KB 

dt = dt.AsEnumerable.GroupBy(Function(r) r("Assignee").ToString).SelectMany(Function(g) g.Take(5)).CopyToDataTable

Regards,

1 Like
4

Thank you it worked!

5

@ramesh_kola
We do understand following:

for each user pickup up randomly 5 records belonging to the user

Variables:
grafik

Flow:
grafik
Readin excel, grouping the data, Preparing the result table

Process the groups

grafik
grafik546×837 40.6 KB

grafik
grafik597×622 70.1 KB

Find starter help here:
ppr_ExcelBox_RameshKola.xaml (12.4 KB)

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.