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

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)

@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