Filtering data table more quickly

[tREX]

Hi,

I read in an excel sheet that is very large and i want to filter the rows based on a string (filteredValue). This method works but takes several minutes to execute due to the size of the data table i presume. is there a faster way to do this?

New to UiPath so thanks for the help

[ppr (Peter Preuss)]

@tREX
Welcome to the forum

you can try if it is faster:
Assign Activity
Left side: dtFiltered - datatype: Datatable
right side:

yourDTVar.AsEnumerable.Where(Function (x) x("Column0").toString.Contains(filteredValue)).CopyToDatatable

In case of the risk of empty filter results apply following pattern:

[tREX]

Hi, Thanks for the help. not sure if i am doing it correctly. see below.

[ppr (Peter Preuss)]

@tREX
just do directly with adopted variable names:

Variables
drFiltered - List (Of DataRow)
dtFiltered - Datatable

Assign:
drFiltered =
dt_DCMaster.AsEnumerable.Where(Function (x) x(“Column0”).toString.Contains(filteredValue)).toList

if Activity
then: dtFiltered = drFiltered.CopyToDataTable
else: dtFiltered = dt_DCMaster.Clone

thats all

[jibanjyoti (Jiban Jyoti Rana)]

Hi @tREX

Welcome to Forum.

Four Ways to Filter Data Tables in UiPath Studio | UiPath

Check the above link, it explains 4 different ways to filter a data table.

Thanks,
Jiban

[tREX]

Hi again,

So i tried as you said but it is showing no matching rows even though there are.

The filterderValue String is “Birdwatch” which is one of the first rows shown below

[ppr (Peter Preuss)]

@tREX
can you please crosscheck this part:
x(“Column0”).toString.Contains(filteredValue)

[tREX]

Okay that is working well now. Thank you very much.

Would i need the empty filter results part at all so?

[ppr (Peter Preuss)]

@tREX

Would i need the empty filter results part at all so?

Didn’t get you.
CopyToDataTable throws an exception if the filter statement is empy and returns no rows. Thats why we do apply this pattern in case of we cannot rely on a mandatory non empty filterresult

[tREX]

Thanks again. Just one last question. How to compare the data table to the string without upper case or lower case affecting the resulting filter?

[ppr (Peter Preuss)]

Are you looking for a canse insensitive filtering?
give a try on
x(“Column0”).toString.toUpper.Contains(filteredValue.toUpper)