How to split datatable into several datatables

Learning Hub Academy Feedback
, ,
1

Here is my database lesson.xlsx (8.4 KB) , I want to split it with “type” and divide it into three datatables which named BD,AI and EB…
However, I don’t know how to use Linq functions to do it…
Can someone help me please… :sob:

image
image1380×776 114 KB

3

@yahmpt
Find starter help here:
SplitToTableList_1Col.xaml (7.2 KB)

4

refer following code
: this code splits dt(DataTable) into DataTable Array by type Column.

dt.AsEnumerable.GroupBy(Function(r) r("type"), Function(r) r).
	Select(Function(r) r.ToArray.CopyToDataTable).
	ToArray
1 Like