Alteryx

Automating Excel Pivot Tables with Alteryx Batch Macros and Server

What were you trying to do? Automate Excel pivot tables. I had a table of data, and from it an Excel-generated pivot table. The pivot table was sorted to show client rankings for different combinations of factors. The factors were changed manually, and the ranking for each client was output to a formatted spreadsheet for… Continue reading Automating Excel Pivot Tables with Alteryx Batch Macros and Server