Can we use Excel Filter activity to filter volume?

Help Activities
1

Dear Experts

I believe we can use this activity to filter volume in an excel file
But I just don’t know how to do it
Can you help show me how to do it in this activity?
For example, there is a column named “Vol”, I need to filter out rows which value <=0 in “Vol”

I just don’t want to use read range->filter data table->write range…

image
image616×275 9.78 KB

image
image714×412 12.9 KB

2

Hi @yangyq10

In the “Column name” field, enter “Vol” The filters you set in the “Configure Filter” option will then apply to that column.

The image shows an Excel filter configuration dialog, specifying the source as "Sheet 1" and the column name to filter as "Vol". (Captioned by AI)
The image shows an Excel filter configuration dialog, specifying the source as "Sheet 1" and the column name to filter as "Vol". (Captioned by AI)560×237 7.28 KB

This is an interface for applying an advanced filter with various conditions and logical operators. (Captioned by AI)
This is an interface for applying an advanced filter with various conditions and logical operators. (Captioned by AI)617×447 10.5 KB

Hope it helps!!

3

Hi @yangyq10

Yes, we can use filter activity

A UI path workflow for processing an Excel file named "BM Table.xlsx", applying a filter to the "Percentage" column in "Sheet1". (Captioned by AI)
A UI path workflow for processing an Excel file named "BM Table.xlsx", applying a filter to the "Percentage" column in "Sheet1". (Captioned by AI)1147×740 33.4 KB

The image shows a workflow in a user interface where an Excel file named "BM Table.xlsx" is being filtered to include rows from Sheet1 where the "Percentage" column's value is less than or equal to 0. (Captioned by AI)
The image shows a workflow in a user interface where an Excel file named "BM Table.xlsx" is being filtered to include rows from Sheet1 where the "Percentage" column's value is less than or equal to 0. (Captioned by AI)1446×743 50 KB

Input:

This image shows a spreadsheet with two columns labeled "Date" and "Percentage," containing various date ranges and corresponding percentage values. (Captioned by AI)
This image shows a spreadsheet with two columns labeled "Date" and "Percentage," containing various date ranges and corresponding percentage values. (Captioned by AI)815×508 6.79 KB

Output:

The image is a screenshot of a spreadsheet showing columns for dates and percentages, with three rows of data starting from row 5. (Captioned by AI)
The image is a screenshot of a spreadsheet showing columns for dates and percentages, with three rows of data starting from row 5. (Captioned by AI)727×425 5.65 KB

Regards,

4

@lrtetala Thank you as always :grin:

1 Like
5

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