How to Filter blank rows using Specific column in a DataTable?

Hi Team,
Please try to help.
Ranjith Ratnala.

@Ratnala1996"ColumnName = ’ ’ "). CopyToDataTable

1 Like

Hi @Ratnala1996

Welcome to the community!! :smiley:
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 :slight_smile:

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 :slight_smile: It could help others too…

1 Like