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

Pivot data and merge cells for header

Andrew_Fischer
6 - Meteoroid

Hi there,

 

I'm having a hard time taking a column (Composite) from my raw data and pivoting it to group by and use as a merged cell column header. This is an example of my raw data set. 

 

Andrew_Fischer_0-1608580200575.png

 

I'd like to use Composite as a merged column header above the AUM, MTD and IndexMTD values so that it looks something like this.

 

Andrew_Fischer_1-1608580307240.png

 

Anyone have any ideas? My input data is attached.

 

Thanks in advance!

 

Best,

Andy

2 REPLIES 2
morr-co
10 - Fireball

Hello @Andrew_Fischer - unfortunately, I do not believe you can output a file with two headers in the format you have specified. I have attached an example that will get you close, but you would need to manually input the second header. Alternatively, you could check the Show Column Headings option in the first table tool. However, it will render the sub header for every record.

 

Screen Shot 2020-12-21 at 3.21.10 PM.png

Andrew_Fischer
6 - Meteoroid

Thank you @morr-co! This is very helpful. I appreciate it!

Labels