Question

how to create VLOOKUP and pivot table using community edition v21.23

  • 23 December 2022
  • 3 replies
  • 1038 views

Badge

Hi Team,

I need to create automate VLOOKUP and pivot table of dynamic data using A360 community edition v21.23 ...is there any command that can help me in the AA workbench.

 

regards,

kiran


3 replies

Userlevel 7
Badge +13

Hi @kiranrtu ,

 

There are no direct approaches for creating Pivot table and performing VLOOKUP through A360 at the moment.

 

I could find a Bot from Bot store through which you can create Pivot table. It is actually supported 11.x platform. But you can try downloading to your local drive and migrate it to A360 supportable format through BOT Migrate package.

 

https://botstore.automationanywhere.com/bot/create-excel-pivot-table-from-report

If I am correct, you can do VLOOKUP through inline scripts like Python or VB (Using Excel macros)

Badge +1

Wish AA adds more excel capabilities 

Badge +5

@Jay 9932  im creating a custom package that helps a lot using datatables to perform filters, formulas an others.

https://github.com/AA-360/A360_Table


 

 

Reply