Get Bottom N records from datatable

[ajaysimha6 (Ajay Simha)]

How to get Bottom N records from Data Table?

[DGKumar1 (DGKumar)]

@ajaysimha6

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

[KarthikByggari]

Refer my post below -

Data Scrapping Suggestion

You can’t directly skip the rows while data scraping. Instead you fetch all pages and take only the required number of rows from the scraped data table. newdt = myDataTable.AsEnumerable().Skip(skipRows).Take(50).CopyToDataTable Skip - Will skip the unwanted rows Take - Will take the next 50 rows Regards, Karthik Byggari

Regards,
Karthik Byggari

[ppr (Peter)]

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

[Palaniyappan (Forum Leader)]

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

AsEnumerable is not a member of 'System.Data.Datatable'

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated. Thank you.

Cheers @ajaysimha6

[Palaniyappan (Forum Leader)]

Kindly let know for any queries or clarification
Cheers @ajaysimha6