How to get the last row value from a datatable

Help Studio
, ,
1

how to get the last row value in datatable

1 Like
2

YourDataTable.AsEnumerable.Last() - will return last Datarow

lets assume a particular column value from the last row
YourDataTable.AsEnumerable.Last()(ColNameOrIndex)

2 Likes
3

how do i take this value in assign What should i take

1 Like
4

let us know on which option you are interested (last row, last row value) and when it is a column value retrieval which datatype do you expect (string, int32…)

1 Like
5

last row value

1 Like
6

lets assume string

Assign Activity:
YourVarName | DataType: String =
YourDataTable.AsEnumerable.Last()(ColNameOrIndex).ToString().Trim

1 Like
8

@T_Y_Raju You can use in datatable in assign activity refer below screenshot

Assign dt = dt.AsEnumerable.skip(dt.RowCount-1).Take(dt.RowCount).CopyToDataTable

image