Get Bottom N records from datatable

How to get Bottom N records from Data Table?

1 Like

@ajaysimha6

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

Refer my post below -

Regards,
Karthik Byggari

3 Likes

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

Hi
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.