We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Help with transforming data to a certain format

D_Y
8 - Asteroid

I have data that currently looks like this, with the first row being the headers:

OrganizationTeamsNorth America   Asia   
  TotalMaleFemaleUnknownTotalMaleFemaleUnknown
Organization 1Red Team Total95319162
Organization 1Red Team 152304112
Organization 1Red Team 243015050
Organization 1Blue Team Total11008260
Organization 1Blue Team 111008260
Organization 2Red Team Total20115140
Organization 2Red Team 120115140

 

I am trying to get it into the following format to help with dashboarding (if there is a better format than this, let me know):

OrganizationTeamsLocationGenderValue
Organization 1Red Team TotalNorth AmericaMale5
Organization 1Red Team 1AsiaFemale1
Organization 2Red Team 1North AmericaUnknown1

 

Kindly asking for help as I tried using the Transpose tool but unsure of the exact steps to perform this transformation.

 

Thanks in advance!

2 REPLIES 2
PhilipL
Alteryx
Alteryx

@D_Y 

Not sure if this is dynamic enough for you, but check out a few of the reformatting methods used, they may help.

D_Y
8 - Asteroid

Thanks for your help! This works!

Labels