How to skip columns using LINQ?

Help Something Else
6

not mandatory

removing the last column we can do:

  • filterdatatable activity -col settings - remove - index: dtData.Columns.Count - 1

Working with DataTableVar.DefaultView.toTable(False, arrColSet)
arrColSet can be done by
DataTableVar.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName.Except({“Col1”,“Col4”,“Col34”}).toArray

2 Likes