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

Pivot

Asteroid

Hi, I'm trying to  build the workflow (attached) to get the desired output (excel pivot example attached). Can someone pls help, i'm new and tried using transpose but must have done something wrong and was giving me an error. Thanking you.

Alteryx Certified Partner

Hi @mnhhs ,

 

You were almost there, you only have to use transpose and cross-tab function to create a output as you desire. 

Take a look at the attached workflow and let me know if that works for you.

 

Best,

Fernando Vizcaino

Asteroid

Hi, thanks for the resolution. Its working great and the same methodology I was able to adopt for other analysis too. Cheers

Alteryx Certified Partner

Great @mnhhs!! Happy to see you evolving with Alteryx!!! 

Labels