Check if the row is empty

I have scraped the data from the above DT and I want to write this data in excel. But, its not skipping the empty cells. When writing in the excel, it leaves the rows and writes further. How do i overcome this?

Hi there @Amrita_Narayan

Have you tried assigning your scraped data table to an activity called duplicate data-table? It will remove duplicates essentially the empty rows.


You can use the filter-data table activity - where condition can be given that if they are ‘empty’ which can be found in the drop-down options in the activity itself :slight_smile:

Hope this helps

I tried both the methods. It’s still the same issue.
The web application only has a table in it. I’m guessing that’s why its not skipping the rows.

Is this a public link? Can I try once?

Can i have a view on the PREVIEW table that appears last before step while data scrapping, may be with a screenshot if possible
Cheers @Amrita_Narayan


Try with this in assign activity to a new datatable.

dtScarpped.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) TypeOf field Is System.DBNull OrElse String.Compare((TryCast(field, String)).Trim(), String.Empty) = 0)).CopyToDataTable()

1 Like

Figured something out.
Thank you all.