Alteryx designer Discussions

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

Display row duplicates on one line

Highlighted
7 - Meteor

Hi folks,

 

Trying to figure out a way to get an end result to show only a single line of data where the source has duplication of names but separate data.

 

Source data is displayed link the following;

  

Person IDPersonStatus 1Status 2Status 3Status 4
A1234Matt Damon00:04:3200:00:0000:00:0000:31:12
A1234Matt Damon00:00:0000:21:1601:12:1300:00:00
A1235Tom Cruise00:12:0001:31:1016:02:4800:09:41
A1236Tom Hardy00:00:0000:00:0000:00:0000:00:00

 

I need it to do;

 

Person IDPersonStatus 1Status 2Status 3Status 4
A1234Matt Damon00:04:3200:21:1601:12:1300:31:12
A1235Tom Cruise00:12:0001:31:1016:02:4800:09:41
A1236Tom Hardy00:00:0000:00:0000:00:0000:00:00

 

Essentially combining the two duplicate lines into a single row that can then be used to join to some additional data. If I try this standalone then it just duplicates all joined data.

 

Any help would be great.

 

Thanks,

 

NikSTHF

Highlighted
Alteryx
Alteryx

Hello,

 

Try using the Summarize tool

 

Group By Person ID

Group By Person

Max Status 1

Max Status 2

Max Status 3

Max Status 4

 

Thanks,

Nick

Highlighted
7 - Meteor

Well aren't you an absolute gemstone. I sat there for ages trying that and moved on to Crosstabs and everything. Cheers buddy!

Labels