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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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