How Split the datatable in rows

[vishal_nachankar (Visky)]

Hi All , I have a datatable and during my processing i want to split the datatable in 4 rows each and perform some actions on those four rows after completing the four next fours i need to pick and perform some action . how can i achieve this can anyone please help me

[vishal.kp (vishal)]

Hi @vishal_nachankar ,

Refer to the following thread to know about splitting the data table based on number of rows:

Split Datatable with Fixed Number of Rows

Hi all! 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,

Regards,

[arjunshenoy]

Hi @vishal_nachankar

You can use the following query to split the data table into chunks of 4 data rows and process accordingly:

Dim chunks = From i In Enumerable.Range(0, dataTable.Rows.Count)
             Group dataTable.Rows(i) By chunkIndex = i \ 4 Into chunk = Group
             Select chunk.CopyToDataTable()

You can then loop through the chunks collection and perform your desired actions on each data table.

Hope this helps,
Best Regards.

[vishal_nachankar (Visky)]

actually the four rows which i get right i will use them as a single string… so what is the output type of chunks?

[arjunshenoy]

@vishal_nachankar

The output type of chunks is IEnumerable(Of DataTable) , which is a collection of DataTable objects. If you want the chunks in a single string, you can use Output Data Table activity for the same.

Hope this helps,
Best Regards.

[vishal_nachankar (Visky)]

Let me try this

[vishal_nachankar (Visky)]

[vishal_nachankar (Visky)]

Getting error

[vishal_nachankar (Visky)]

Getting Error

[Anil_G (Anil Gorthi)]

@vishal_nachankar

Please try this. It is exactly same with different chunk size

Insert data in queue with Bulk add Queue items error

@Deep_HML To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those… And yes the limit is 15k or so… We can break the table into rows of 10k and add in 3 loops So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable And use the chun…

cheers