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

Multiple Column Headers with Table Tool

ajapczynski
5 - Atom

Hi,

 

I have a sample data that looks like this:

LifePaulJohnBettyMethod
31005001000Method 1
52006002000Method 1
710007003000Method 1
151508004000Method 1
39400009005000Method 1
310450900Method 2
530550800Method 2
7500650700Method 2
15200750600Method 2
3930000950500Method 2

 

And I would like to use the Report Tool to make the end result look like this:

 

ajapczynski_0-1594163856089.png

 

In essence, I need two header rows one for the person's name and then underneath that person's name method 1 amounts and method 2 amounts. I have attached the sample data and desired output. 

 

Any help would be much appreciated!

 

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @ajapczynski ,

 

There is no native way of doing that, but here is a great example from @JohnJPS .

https://community.alteryx.com/t5/Alteryx-Designer/Multo-row-header/td-p/29185

 

Best,

Fernando Vizcaino

ajapczynski
5 - Atom

Thanks that worked!

Labels