Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Results from Union tool into table format

ulrich_schumann
8 - Asteroid

Hi all,

1. I run a monthly query with a set of tools and output a single average value per Business Area with the SUMMARIZE tool.

2. In the next month, I copy the existing workflow, change the source of input file and bring the result from last month and this months together with the UNION tool.

My output shows the months and the average value per month and Business area.

3. For all upcoming months I repeat step 2.

The output of my results will be shown in Excel under the results from the previous months.

Now my question: is there any chance to get the output into a table format?

 

My results:

Jan  Business Area 1  24

Jan  Business Area 1  19

Jan  Business Area 1  27

Jan  Business Area 2  17

Jan  Business Area 2  11

Jan  Business Area 2  14

 

I would like to see:

                                Jan   Feb   Mar    

Business Area 1        24     19     27      

Business Area 2        17     11     14      

 

Any ideas?

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

Have you tried the CROSSTAB tool?

 

Groupby [business area]

 

header - month

data - value

 

Calculate

sum

 

that might solve your need. 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels