Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiple Rows to Single Row

dataguy
7 - Meteor

Hi,

 

I have the original data set (see below) that I want to transform into desired data set (see below). I have been trying to summarize and concatenate with not a lot of success. I would really appreciate any help in this matter.

 

Original Data set:

 

IdProductNumber of Passed CoursesNumber of times failed
1A20
1B31
1C41
2A61
2C52

 

Desired Data set:

 

IdA # of PassA # of failB # of PassB # of failC # of PassC # of Fail
1203141
2610052

 

 

 

 

2 REPLIES 2
gnans19
11 - Bolide

@dataguy Combination of Transpose and Crosstab would do the magic.

 

Attached workflow. Hope this helps.\

 

P.S:. Having # in column names is replaced by underscore by Alteryx

dataguy
7 - Meteor

Thanks! I am working on this. Overall, this looks good. 

Labels