Solved

How to achieve Excel Vlook up and Pivot ?

  • 10 June 2024
  • 1 reply
  • 23 views

Badge +4

Hi, How can we achieve Vlook up and Pivoting in AA 

icon

Best answer by DK 964 12 June 2024, 15:07

View original

1 reply

Userlevel 1
Badge +3

Hi @mandarB ,

As of now, Automation Anywhere A360 does not directly support creating pivot tables or performing VLOOKUP. However, there are alternative approaches you can explore:

  1. Pivot Tables:

  2. VLOOKUP:

    • A360 doesn’t have a direct command for VLOOKUP. However, you can achieve this through inline scripts:
      • Python: Use Python scripts within your automation to perform VLOOKUP-like operations.
      • VB (Excel Macros): Create custom Excel macros to handle VLOOKUP tasks.

Remember that A360 is continuously evolving, so keep an eye on updates and new features. For detailed documentation, visit the Automation Anywhere Documentation2. 😊🤖

Reply