Please try to help.
Datatablename.select("ColumnName = ’ ’ "). CopyToDataTable
Welcome to the community!!
You can use the Filter Data Table activity to filter out blank records.
Using this activity, you can either remove the blank records, or you can remove the rest and keep the blank records. There is a option to remove or keep
Attached workflow is an example for you to remove blank rows and keep the rest
FilterDataTable.xaml (5.8 KB)
If this works for you, please make sure to mark my answer as the solution too It could help others too…