Hi, How can we achieve Vlook up and Pivoting in AA
How to achieve Excel Vlook up and Pivot ?
Hi
As of now, Automation Anywhere A360 does not directly support creating pivot tables or performing VLOOKUP. However, there are alternative approaches you can explore:
-
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.
-
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.
- A360 doesn’t have a direct command for VLOOKUP. However, you can achieve this through inline scripts:
Remember that A360 is continuously evolving, so keep an eye on updates and new features. For detailed documentation, visit the Automation Anywhere Documentation2. 😊🤖
![Collaborator Bronze Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/fee7f4b5-b93b-4ad9-b9d0-d7e4b4be4c9a_thumb.png)
Here is the answer i generated with goodgist for your query. Please let me know if this is helpful
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/f62c4f04-62a4-400d-8775-ecb18a5817a5.png)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.