How to remove empty row in data table without shartname?

Help Studio
, , , ,
1

use this datatable

shrtname KCH KCN KHC KHO KSM KTN KTV
8-15
3-7 2 2 22 1
30 Above
16-30
1-3 14 36 39 9 68 50 1
Total 16 36 41 9 90 50 2
2

Hi @saninfo273

Try this:

dataTable = dataTable.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row.Field(Of String)("shrtname"))).CopyToDataTable()

Regards

3

how to use this method???

4

Hi @saninfo273

Use the syntax in Assign activity. Share your expected output too

Save To: dataTable

Value To Save: dataTable.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row.Field(Of String)("shrtname"))).CopyToDataTable()

image

Regards

1 Like