Can I apply filter to 2 columns in excel?

Help Activities
, , , , , , ,
1

Hi All,

I have a use case where I have to apply filters on 2 columns in excel. In the 1st column I need to filter values containing “-” and in the 2nd column I need to filter non-empty values. I have been trying to do this by using excel modern filter activity, using 2 of them one after the other, but the issue is that the filter activity somehow clears filter from other columns before applying filter on a particular column. Hence, I am not able to apply filter simultaneously on the 2 columns. Can somebody please help on this?

2

Hi @Shobhit_Jain_IN

Can you try this

The image showcases an automated Excel process in a workflow visually designed to filter data from columns named 'Product' and 'Amount' in a sheet titled 'Sheet1' of a specified Excel file. (Captioned by AI)
The image showcases an automated Excel process in a workflow visually designed to filter data from columns named 'Product' and 'Amount' in a sheet titled 'Sheet1' of a specified Excel file. (Captioned by AI)558×702 22.1 KB

Filter1:

The image displays a software interface for setting advanced filtering parameters. (Captioned by AI)
The image displays a software interface for setting advanced filtering parameters. (Captioned by AI)607×450 12.1 KB

Filter2:

The image shows a filter options dialog box with criteria selection and condition settings for data filtering. (Captioned by AI)
The image shows a filter options dialog box with criteria selection and condition settings for data filtering. (Captioned by AI)617×451 12 KB

Input:

This image shows a spreadsheet table with columns labeled 'Product,' 'Amount,' 'Feb,' and 'Mar,' listing numerical data for corresponding items. (Captioned by AI)
This image shows a spreadsheet table with columns labeled 'Product,' 'Amount,' 'Feb,' and 'Mar,' listing numerical data for corresponding items. (Captioned by AI)570×281 3.63 KB

Output:

The image shows a spreadsheet with columns labeled Product, Amount, Feb, and Mar, containing data for product A-123 with corresponding values. (Captioned by AI)
The image shows a spreadsheet with columns labeled Product, Amount, Feb, and Mar, containing data for product A-123 with corresponding values. (Captioned by AI)797×347 4.62 KB

Regards,

3

@Shobhit_Jain_IN

Welcome to Community!!

you can filter Data table activity where you can filter your data table after reading the excel file. You can add multiple columns how many you want..

1.Read Range Workbook Activity to read your excel file. create output variable
2.Use Filter data table activity in input Pass above output variable and in Output variable you can create Data table variable.

The image shows a Filter Wizard interface for configuring a filtering rule on a data table with options to specify conditions and values. (Captioned by AI)
The image shows a Filter Wizard interface for configuring a filtering rule on a data table with options to specify conditions and values. (Captioned by AI)750×521 19.4 KB

in above screenshot you can click + icon you can add more conditions with your columns.

Follow below tutorials

4

Hi @Shobhit_Jain_IN

Welcome to UiPath,

Pls add a Filter Table activity, Select the table and set two filter conditions.
then Set Column1 to contains “-” and Column2 to is not empty.

If you found helpful, Mark as a solution tick .
Happy Automation

5

You can use linq for this for exact results.

filteredDT = yourDataTable.AsEnumerable().
Where(Function(row) row(“ColumnA”).ToString.Contains(“-”) AndAlso Not String.IsNullOrWhiteSpace(row(“ColumnB”).ToString)).CopyToDataTable()

Mark solution if its help happy Automation :blush: