Get Bottom N records from datatable

How to get Bottom N records from Data Table?

1 Like


For getting the count of the datatable you can use : DataTable.Rows.Count like this you can last row count.

Refer my post below -

Karthik Byggari


have a look on the Take and Skip Methods available on DataTableVar.AsEnumerable.Skip(…).Take(…)…

expression like this in assign activity
datatable = datatable.Asenumerable().Skip(N).CopyToDatatable()
where N is the first set of records to be neglected so that we will be able to get the BOTTOM N records.

if you are facing any issue like asenumerable is not there

Cheers @ajaysimha6

1 Like

Kindly let know for any queries or clarification
Cheers @ajaysimha6

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