Delete empty row from Datatable

[Arun2yu (Arun Kumar P)]

Hi,

My requirement is to remove the empty row from Datatable. My Datatable has only one column and always the empty row comes as first.

[arivu96 (Arivazhagan A)]

Hi @Arun2yu,

Refer this post,

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Regards,
Arivu

[Arun2yu (Arun Kumar P)]

Hi @arivu96,

Thanks for your response. This Assign parameter approach looks to be delete all the empty rows in datatable. But my requirement is to delete the first row only if it is empty field and the remaining rows should be populated irrespective of empty condition check (I.e., except first row, the remaining rows should be populated even if it is empty field.)

[arivu96 (Arivazhagan A)]

Hi @Arun2yu,

Use assign activity
Dt=dt.select("columnname <> ''"). CopyToDataTable()

Regards,
Arivu

[david.castellanos]

Wooww!!! works perfectly, thanks!!