ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Summarize data

SylviaK
8 - Asteroid

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

fmvizcaino
16 - Nebula
16 - Nebula

Hi @SylviaK ,

 

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

fmvizcaino_0-1593455160148.png

 

 

BEst,

Fernando Vizcaino

Maskell_Rascal
12 - Quasar

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