Delete empty row from Datatable

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.

1 Like

Hi @Arun2yu,

Refer this post,

Regards,
Arivu

5 Likes

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

Hi @Arun2yu,

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

Regards,
Arivu

3 Likes