Solved

How to filter multiple values in excel with filter command

+4

Hi everyone,

I have a question about data from excel. I would appreciate it if someone who knows answer.

I want to apply more than one filter to a single column with the filter command, but I could not do it.

I need to put a date filter in the column. (Today's date)
But I couldn't do this with text or number filter.

Is it possible to do this with AA360?

Thanks in advance.

Best answer by DATTA.KOTHAMASU

Hi, based on a series of tests, here are my findings:

Excel Advanced Filter: It appears that this command allows filtering based on a single filter value per column. It is also capable of filtering date columns when the filter type is set to text.
Filtering Multiple Conditions: If your goal is to apply multiple filter conditions on a specific column within an Excel file, you have a couple of options:
- Using Macros: To filter directly within Excel, macros can be implemented to handle more complex filtering scenarios.
  https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/excel-advanced-package-run-macro-action.html
- Using Excel as a Database: To filter the Excel file and read the data based on multiple conditions in a specific column, you can utilize Excel as a database, which provides more flexibility and functionality for complex filtering criteria.
  https://community.automationanywhere.com/pathfinder-blog-85009/quicktip-connect-to-an-excel-spreadsheet-as-a-database-85039

Please mark the response as a solution if it helps you.

+11

Hi, based on a series of tests, here are my findings:

Excel Advanced Filter: It appears that this command allows filtering based on a single filter value per column. It is also capable of filtering date columns when the filter type is set to text.
Filtering Multiple Conditions: If your goal is to apply multiple filter conditions on a specific column within an Excel file, you have a couple of options:
- Using Macros: To filter directly within Excel, macros can be implemented to handle more complex filtering scenarios.
  https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/excel-advanced-package-run-macro-action.html
- Using Excel as a Database: To filter the Excel file and read the data based on multiple conditions in a specific column, you can utilize Excel as a database, which provides more flexibility and functionality for complex filtering criteria.
  https://community.automationanywhere.com/pathfinder-blog-85009/quicktip-connect-to-an-excel-spreadsheet-as-a-database-85039

Please mark the response as a solution if it helps you.

Datta Kothamasu