Neither of the current connectors have this capability out-of-the-box. It is possible to do with a C# script though. It would certainly require some programming experience though. You can search for "C# Excel interop pivot table" and find some helpful code examples. You could use the Script component to write that code and have your automation call it.
Posted: 7 months ago
Posted: 6 Nov 2020 15:25 EST
Thomas Sasnett (ThomasSasnett)
Lead Robotics Architect u2013 Pega Consulting