I have a datatable with more than 90k rows (this number of rows will be changing depending on the inputs).
What I want is to split always with a max number of rows (always max of 40k rows):
For example, if I have 92k lines, generate 3 datatable.
- Datatable 1 -> Rows 0 to 39.999
- Datatable 2 -> Rows 40.000 to 79.999
- Datatable 3 -> Rows 80.000 to 92.000
Please, could you help me? I didn’t found something like that.
Thanks in advance,