How to extract "specific data rows" from excel

Hi,

How can I extract all of the data roles that has “LT” rank into a new excel?

From:
image

To:
image

Do I have to use the Excel Application Scope, then read the excel fast, and do a filter table that contains “LT” in rank column?

table= table.select("‘columnname’=‘LT’").copytodatatable()

or use filter table activity and configure your column name and value

1 Like

@Hey_hi
check this → Four Ways to Filter Data Tables in UiPath Studio | UiPath

1 Like

Hi @Hey_hi ,

Here we go… Specific data rows…Xaml attached

Extract Specific Data rows.zip (13.3 KB)

1 Like

DT.Asenumerable.Where(Function(r) r(“Rank”).Tostring.Trim.Tolower.Equals(“lt”)).Copytodatatable

Output : Datatable With Rows Having “LT” only.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.