Consider der are n rows. I need to divide the datatable for each 999 rows.
Example :
If the Excel sheets contains
1)1000 rows then two data tables need to be created one with 999 rows and the other with 1 row.
2)If the Excel contains less than 999 rows then the Single datatable is enough.
Please help me with this. Note : The EXcel Sheet contains the large amount of data
Use Read Range activity and declare a Variable for Output in Datatable, Let’s say Dt
Use Assign activity and write as DtRows = Dt.Rows.Count
Use If condition and write as Dt.Rows.Count < 999
Then : Nothing to do
Else : Use Assign activity as First999dt = dt.AsEnumerable.Take(999).CopytoDatatable
: Use Assign activity as Second999dt =
dt.AsEnumerable.Skip(999).CopytoDatatable