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,