DATATABLE Split into Chunks

[vishal_nachankar (Visky)]

Hi I have a datatable with lakhs of rows into it . now i want to Spit the datatable into chunks of 30000 and add it to the excel file … How can i acheive this

[arjunshenoy]

Hi @vishal_nachankar

Please look into the following thread:

Split Datatable into 4 different tables

Hey guys, So i generate a datatable with 100+ rows every week. Now i’d like to split that table into 4 parts with about equal numbers of rows in each. Found some rather complicated solutions but is there a simple way to do this? And also a random question: What would be the best language to learn to improve in UIpath? C#? Thanks,

Best Regards.

[Anil_G (Anil Gorthi)]

@vishal_nachankar

Please check this

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

[Yoichi]

Hi,

Hope the following sample helps you.

arrDt = Enumerable.Range(0,(dt.Rows.Count \ chunkSize)-CInt(dt.Rows.Count mod chunkSize >0)).Select(Function(i) dt.AsEnumerable.Skip(i*chunkSize).Take(ChunkSize).CopyToDataTable).ToArray

Sample20230427-5L.zip (8.6 KB)

Regards,