Pivot Table in Alteryx

Hey there! I am trying to alter the layout of some data to be easier to read. We have been manually doing this through excel pivot tables and want to automate it with Alteryx to look. Does anyone have any recommendations? I included photos of what I start with and what I need to end with below. Thanks!

Tips and Tricks

Accepted answers

All comments

messi007

@tgilbert,

Could you share a sample data instead of screen shot ?

It will help us to give you the solution.

Regards,

Here you go, thanks!

Here you go :

Attached the workflow,

Regards,

Master.yxzp

tgilbert

Thanks @messi007 this is amazing! For the render tool, do you know if there is a way to set it up to auto name itself based on the location number? Eventually this workflow will be designed to run 100+ locations and I don't want to name all the files individually.

Also, we typically add some instructions in the first 3 rows above the worksheet. Do you know a way to have alteryx add that? I've attached an example of what I am talking about. Thanks for all the help!

CPS Instructions.xlsx

tgilbert

CPS Instructions.xlsx

ddiesel

Hi @tgilbert !

@messi007 might not have seen your post because I don't think the tag stuck.

Short answer is yes to both.

You can dynamically name the files by creating a filename with the formula tool.

You can add instructions to the top of the worksheet as a headers. There are many options for formatting your output in the Reporting category of tools.

Try it out and let us know if you need any further assistance.

messi007

@tgilbert,

Please see below the quick update. I'll let you update it according to your need

Hope this helps!

Regards

Master.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703