Splitting data table

Help Activities
#1

Hi All,

I have a datatable of n columns. The value of N can vary. I want to split the data table into two data tables. First datatable will have column 1 to column 5. And the second data table will have column 6 to column n.

This can be done using loop and Remove Data Column activity. However wanted to check if there is any simpler way.

Thanks you!

#2

You can use DataView.ToTable(). E.g.

dt1 = dt.DefaultView.ToTable("table1", True, dt.Columns.Cast(Of DataColumn).Take(5).Select(Function(c) c.ColumnName).ToArray)
dt2 = dt.DefaultView.ToTable("table2", True, dt.Columns.Cast(Of DataColumn).Skip(5).Take(N-5).Select(Function(c) c.ColumnName).ToArray)
1 Like
#3

Hi @Kapil,

You can use filter activities as a simple way of splitting table

To Get the first 5 columns, select the Keep Column option in the output column and give 0-4 column ids
To get the 6-n columns, select the Remove column option in the output column and give 0-4 column ids

image

1 Like
#4

thank you @ptrobot and @VIDHATHA_THADURI !! I wish it was possible to mark both answers as Solution.