Alteryx Designer Desktop Discussions

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

Pivot Table Possibility?

bryan_ram2613
8 - Asteroid

Running into a snag on how to solve this problem. Relatively new to designer. Here we go.

 

How would I get this

 

ZipService Line
45067Heart
45212Heart
45067Comp Medicine
45026MSK
45212Comp Medicine
45067Heart
45078MSK
45026MSK 

 

To become this?

 

ZipComp MedicineHeartMSK
450671 2 
452121 1 
45026  2
45078  1

 

I have been playing with the multi row formula tool and the of the transform tools. 

 

Any help is much appreciated! Thanks!

2 REPLIES 2
mmenth
11 - Bolide

Hi there,

 

The transform tools are great for pivoting! See the attached workflow!

 

 

bryan_ram2613
8 - Asteroid

Easy as that! Thanks. Much appreciated

Labels