Is it Possible to Remove Rows Using : GroupBy, Dictionary and LINQ?

[hsendel]

Dears,

I have build one workflow to remove rows which are empty as follows:

1- Read Range

2- Filter DataTable

3- Write Range

But it’s execution is taking too much time because I have more than 100 Rows … Is it Possible to Remove Rows Using : GroupBy, Dictionary and LINQ or any other fastest Method ?

Thanks in Advance

[ppr (Peter)]

@hsendel

I have build one workflow to remove rows which contains special word as follows:

currently it looks like rows where the pay column value is empty will be removed. But in the text it is mentioned “special word”. What is needed?

Removing datarows we can do by filtering as mentioned here:

Four Ways to Filter Data Tables in UiPath Studio | UiPath

[hsendel]

Thanks @ppr for quick reply and noticing the “Special Word”, I’ve updated the text … I will try those shared 4 Methods

[vishal.kp (vishal)]

Hi @hsendel ,
You can use dt.AsEnumerable.Where(function(x) not string.IsNullOrEmpty(x(“Column Name”).ToString)).CopyToDataTable
This will give you the desired output

[ppr (Peter)]

For a defensive and strict filtering on the rows with a non blank column we can do:

Variables:

Filtering:

As CopyToDataTable will throw an execption for an empty filter result we avoid this by checking the returned result in advance:

[hsendel]

Dear @ppr , I will implement the same and update you.

[hsendel]

Hi @vishal.kp
Thanks for your feedback, I will check this and update you.

[ganesh4 (Ganesh)]

Outputdt=Dt1.asenumerable.where(Function(x) x(“Pay”).tostring.trim<>“”).CopyToDataTable

Using this LINQ method you can achieve this

[ermanoj3101 (MANOJ)]

Try this and let me know if you face any issue.
RemoveBlankRows.xaml (5.3 KB)