Check if the row is empty

[Amrita_Narayan]

Hey,
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?

[Raghavendraprasad (Raghavendraprasad Bhat)]

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.

OR

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

Hope this helps

[Amrita_Narayan]

Hey,
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.

[Raghavendraprasad (Raghavendraprasad Bhat)]

Is this a public link? Can I try once?

[Palaniyappan (Forum Leader)]

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

[sarathi125 (Parthasarathi)]

Hey,

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

[Amrita_Narayan]

Figured something out.
Thank you all.