Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Summarize data

Highlighted
7 - Meteor

Hi, 

 

I am trying to  get Output 1 and Output 2 based on the preceding columns. Can someone pls help?Query.PNG

 

Many thanks, 

Sylvia

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @SylviaK ,

 

You can do that with the transpose + summarize combination as shown below.

fmvizcaino_0-1593455160148.png

 

 

BEst,

Fernando Vizcaino

Highlighted
9 - Comet

Hi @SylviaK 

 

You can get this by using the transpose tool, formula, and summarize tool. See the attached workflow. 

Maskell_Rascal_0-1593455155882.png

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Thanks!

Phil

Labels