How to achieve Excel Vlook up and Pivot ?

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:

   • While A360 doesn’t have built-in pivot table functionality, you can create pivot tables using external tools (e.g., Excel) and then integrate them with your A360 automation.
   • Consider using the Bot Store to find a pre-built bot that creates pivot tables. You can download it to your local drive and then migrate it to a format compatible with A360 using the BOT Migrate package1.

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. 😊🤖