Delete Empty Row Output

[Aluneth_X]

Hello guys !
so i tried to print value from datatabe

but i got two result the first one is empty and the second one is the right value

can you guys help me to delete that empty output
so the output should be

thank you

[Shubham_Varshney]

Put a filter datatable as to remove the blank spaces!!!

Easy way

[Palaniyappan (Forum Leader)]

Fine
Before this writeline activity
—use a if condition like this
Not String.IsNullOrEmpty(row(“ItemUnitPrice”).ToString)

If true it will go to THEN part where we can have our writeline activity and mention the output
So that it won’t display empty output
row(“ItemUnitPrice”).ToString

Cheers @Aluneth_X

[sandeep13 (Sandeep Pathak)]

@Aluneth_X
You can use select method to remove empty row
Like
Datatable.select(columnname != " ")

[chenderson (Cary Henderson)]

Good morning Aluneth,

Just to throw out a different (but similar to the ones above) approach.

If you ever want to remove all empty rows from your datatable, you can use the following code in an assign stage:

DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable()

[Arpit_Kesharwani]

best solution