How to partially extract data (some count of rows) from existing datatable to another dataTable

Hello,
Please help with this task.
I have a dataTable1 (for example it contains 1000 rows)
I want to create another dataTable2 which willl have data from dataTable1 (existing rows from 200 to 400)
How can I do it?
Thank you.

Hi @yaniketz

What data you have in your DT1 and how you want to filter it to put it in DT2?

Please try the below expression with the assign activity.

newdt = myDataTable.AsEnumerable().Skip(200).Take(200).CopyToDataTable

Skip - Will skip the first 200 rows
Take - Will take the next 200 rows

Regards,
Karthik Byggari

6 Likes

A huge thank you!

1 Like

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