How to filter multiple values in excel with filter command

Question

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.

DATTA.KOTHAMASU · Accepted Answer

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.

ufuksavas · Answer

thanks for your answer

Reply

Sign up

Login to the Pathfinder Community

Scanning file for viruses.

This file cannot be downloaded