SAP iRPA : How to create pivot table in excel using sap irpa

[former_member698672]

Hi All,

I have an automation scenario where I need to create a pivot table for the data in the excel spreadsheet and analyze the data.

Could you please suggest me how can I automate the pivot creation in SAP iRPA considering the number of columns and name might change .

Thank you.

Vibhor

[Sowmya_Balapanur]

Hi, can any one help how can we create a pivot tabel in a new sheet based on other sheet data.

[Jerome]

Hello,

As the number of columns and name might change, I'm not sure that creating a pivot table using a bot is the best way to go (assuming it's possible, the same bot would not be able to determine what columns you want to use...)

What I would suggest is :

- create your table structure and also the pivot table which is linked

- with a bot, populate your table

- use this blog post which explains how to refresh your pivot table with its new data

Regards,

J.