Hello, Due to a high data volume, I need to split a data table into two data tables with the same structure (about the same proportions). The first column of the data table named “Category”, as it says contains the category of the data. In order to avoid having rows of the same category in the bo…

If the values under category column is in-order (sorted), then you may follow the following steps: Store the value of int_RowIndex = CInt(Math.Round(DT0.Rows.Count/2,0)) into a integer variable. find the category str_category = DT0(int_RowIndex+1)(“Category”) Then use the logic to get DT1 and DT2…

Split a DataTable into two based on a column group

Help Something Else

SONYC (SONYC) September 19, 2024, 1:52pm 5

Thank you @Anil_G for your suggestion.
It works for a decent amount of data.
I’m talking here about a huge CSV file, that’s why I need to split the data, in order to store it into two or more Excel sheets.

Topic		Replies	Views
How to split datatable based on Group by and values in a column in Linq Query? Please Help Help	5	3016	August 16, 2020
Group and divide Data Table using LINQ Studio datatable , excel , studio , question , linq	5	3440	February 18, 2022
Datatable - Grouping Data on 3 Columns - Split on different Data Tables Studio	6	3503	March 12, 2022
How to split a data table using a row index Academy Feedback datatable , activities , question	1	2552	September 3, 2020
How to split datatable into several datatables Academy Feedback datatable , activities , question	2	2735	November 27, 2020

Split a DataTable into two based on a column group

Related topics