Alteryx Designer Discussions

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

Transposing/Pivoting Stacked Column Data

lomeoari
7 - Meteor

Hi all,

 

I attached some sample data of the formatting of the original data and the desired output. To start, I tried to get to the desired output by just using the Username and email, and was able to do so via the attached workflow. However, not having any luck on figuring out how to apply to the rest of the data. Any ideas?

3 REPLIES 3
drew9
9 - Comet

Hi @lomeoari ,

 

I was able to get the data in the desired format. See attached.

 

Hope this helps!

kelsey_kincaid
11 - Bolide

Hi @lomeoari ,

Whenever I have data in a single workbook that is shaped differently I follow a process like this:

  1. Group the rows into record numbers. In your case, that means finding a way to group every row associated with User name AB123 into a single record number, and every row associated with user name CD456 into a different record number.
  2. Separate the differently shaped data into two different sets
  3. Get both sets of data into the same shape
  4. Blend back together 

I attached an example here - let me know if this works for you!

kelsey_kincaid_0-1634155530976.png

 

 

fmvizcaino
16 - Nebula
16 - Nebula

Hey @lomeoari ,

 

Not my proudest workflow, but it does the job 😁

fmvizcaino_0-1634155744755.png

 

Best,

Fernando v.

 

Labels