Filter Data Table on Row position

Help StudioX
,
1

I need to filter a data table on row position, e.g all rows before row 10 i.e positions 1-9 (this value will change each time filter is done) , how would I do that?

2

Hi @gurdev.singh

Can you try this

RowPosition = 9
FinalDT = InputDT.AsEnumerable.Take(RowPosition).CopyToDataTable

Regards,

3

@gurdev.singh,

Share some example how you want it.

4

Hi @gurdev.singh ,
Use below syntax
dt=dt.AsEnumerable().Skip(n).Take(m).CopyToDataTable()

Skip(n): Skips the first n rows.

Take(m): Takes the next m rows after skipping.

Regards,
Arivu

1 Like