Get last row of DataTable

[hansgeeroms]

Hello everyone,

I’m having a datatable like this:

Column A Column B Column C
marc male m
Ellen female v
Bart male m

I want to get the last row of my datatable into a new datatable. So that my new datatable gives:
Column A Column B Column C
Bart male m

How can i do this?

[ak3430 (Anil Kumar)]

Hello hansgeeroms,

use value = Dt.count

it gives exact count of table and read last row based on value -1

[ranjith]

@hansgeeroms Try this query

new_DT = DT_input.asenumerable.reverse().take(1).copytodatatable

[hansgeeroms]

@ranjith

.asenumerable.reverse().take(1).copytodatatable

Thanks!!!