Delete empty row from Datatable


#1

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.


#2

Hi @Arun2yu,

Refer this post,

Regards,
Arivu


#3

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


#4

Hi @Arun2yu,

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

Regards,
Arivu