Get some rows from a datatable

Help Studio
1

Hi,

I’m trying to get a group of rows in a datatable. For example if I had a 50 rows datatable I’m interested just from 40 to 45. How can I do it?

Thank you in advance

2

Hi @mmarcos

→ Use Read range workbook activity to read the excel and store in a datatable called inputDataTable.
→ Then use assign activity to write the below linq expression to get rows from 40 to 45,

- Assign -> filteredRows = inputDataTable.AsEnumerable().Skip(39).Take(6).CopyToDataTable()

Hope it helps!!

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.