How to split datatable into several datatables

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:

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

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).
1 Like