How to remove empty row in data table without shartname?

[saninfo273]

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

[vrdabberu (Varunraj Dabberu)]

Hi @saninfo273

Try this:

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

Regards

[saninfo273]

how to use this method???

[vrdabberu (Varunraj Dabberu)]

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()

Regards