How to remove blank row from dataTable

[Mangesh_kulkarni]

Hi guys,
I m new to UI path. I m scrapping data from 1 website in which i m getting blank row in my data table.
So how to remove if there is no data (Blank)

[Lucas.Pimenta]

Hello!

Welcome to UiPath World

I think the best way is to do a Select on your Datatable.

Refer to this:

How to remove empty cells from datatable?

Hi @Paresh, Try this one. DataTableName.Select("Convert([Part Number], System.String)< >''").CopyToDataTable() Or DataTableName.Select("[Part Number]< >''").CopyToDataTable() Regards, Arivu

Hope It Helps

Regards,

[Divyashreem (Divyashree Muddagangaiah)]

you can loop through the data table and check item.ToString.Length>0(with specific row item) and then proceed with your next operations.

[arivu96 (Arivazhagan A)]

Hi @Mangesh_kulkarni,

Refer this post,

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Regards, Arivu

[josh.cusack (Josh)]

Hi Arivu,

I have tried using this code but it seems to only work for the first 28 lines. is there anything in this code that would limit this, or is it more likely a specific part of my parameters?