community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Assistance with Pivoting Dataset in Alteryx

Hi,

 

As part of a project, every dataset to be consumed is formatted like this:

 

1.PNG

 

And I need it formatted like this:

2.PNG

 

This obviously needs more than just the pivot tool.  Is this something that can easily be done in Alteryx?  I've attached a sample dataset.

Alteryx Partner

This should do it :)

Quasar

Here is solution for your case. Hope this is helpful. workflow.PNGResults.PNG

 

 

This worked perfectly and was exactly what I was looking for!

 

I like the logic behind the workflow.  Thank you again!

This solution also worked, so thank you for sending that through!  The first solution just appeared slightly more elegant but I guess that is very subjective.

 

Thanks again.

Labels