Obtaining all records from a unique identifier onto the same row

Hi all,

I apologize in advance because I'm sure this has been asked before; I just can't find the thread.

I've attached an example of what data I have and what I'm hoping to generate.

I'm essentially trying to cross tab (?) all records from the same person into a single row. Likely I'm overthinking what I need to do here, but nothing I've tried has worked.

Thanks, from an Alteryx newbie.

SampleProblem.xlsx

Workflow

Tips and Tricks

Best Practices

Accepted answers

phottovy

Hi @johnmatta

I had to get creative to keep the fields in the same order but this should get you to the results you are looking for:

Output:

Combine Rows.yxmd

All comments

IraWatt

Hey @johnmatta

Here is one way to do this:

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

phottovy

Hi @johnmatta

I had to get creative to keep the fields in the same order but this should get you to the results you are looking for:

Output:

Combine Rows.yxmd

IraWatt

@phottovy that's a pretty nice workaround to stop the cross tab from scrambling the order! learned something new 😄

Matt_D

Here is another

Obtaining all records from a unique identifier onto the same row.yxzp

johnmatta

Thank you!

johnmatta

Thank you! This was exactly what I needed. Now to apply it to 6M records 🤣

IraWatt

Best of luck @johnmatta 😅

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703