Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Transpose data set by column value and row value

Andrew_Fischer
6 - Meteoroid

Hi there,

I'm having a hard time transposing a data set and am wondering if someone could please help? I need to group by the Name column and the dates, which are in row 1.

 

I have something like this: 

Andrew_Fischer_0-1602535755086.png

 

Need something like this:

Andrew_Fischer_1-1602536101487.png

 

Attached is the input example. Thank you in advance!

 

Best,

Andy

5 REPLIES 5
Blake
12 - Quasar

Hey @Andrew_Fischer 

 

You'll want to split your "headers" (the dates) off from your main table and transpose them separately. 

JosephSerpis
17 - Castor
17 - Castor

Hi @Andrew_Fischer I mocked up a couple of ways to approach this that produces the output you describe. Let me know what you think?

Andrew_Fischer
6 - Meteoroid

Thanks for the help @Blake! I didn't see the workflow attached. Do you mind attaching?

Blake
12 - Quasar

Hey @Andrew_Fischer  - sure thing! 

 

Sorry about that, thought I'd attached it before.

 

Andrew_Fischer
6 - Meteoroid

Thanks again @Blake !!

Labels