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

[Ratnala1996 (Ranjith Ratnala)]

Hi Team,
Please try to help.
Regards,
Ranjith Ratnala.

[lakshman (Ganta lakshman)]

@Ratnala1996

Datatablename.select("ColumnName = ’ ’ "). CopyToDataTable

[Lahiru.Fernando]

Hi @Ratnala1996

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…