Question

How to filter multiple values in excel

  • 21 February 2023
  • 4 replies
  • 438 views

Badge

How to filter multiple values in excel with automation anywhere ?

this documentation only show one value text option: https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-using-filter-table.html

and I have a problem with filter table 2 or more value, or any another way ?
 


4 replies

Badge

I have the same problem, but looks AA cannot do this, they need to develop and release this function, they are still far behind of what UIPATH can do

Badge +1

Hello there,

You can use Automation Anywhere to select the column where you want to apply the filter then Automate the process of specifying multiple values you want to filter. This might involve entering each value manually or reading values from an external source. Once the values are specified, use Automation Anywhere to apply the filter.

Hope this will be helpful.

Userlevel 4
Badge +14

Hey @Romy 4794, for multiple filters you can use simulate keystrokes action inside excel sheet, inside advanced filters.

 

Badge

Hello,

You can use run macros in an excel:

 

or

you can filter according to a range:

 

Hope this will be helpful.

Reply