Obtaining all records from a unique identifier onto the same row

[johnmatta]

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.

[IraWatt]

Hey @johnmatta 

Here is one way to do this:

Any questions or issues please ask :)
HTH!
Ira

[phottovy · Accepted solution]

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:

[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 :)

[johnmatta]

Thank you!

[johnmatta]

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

[IraWatt]

Best of luck @johnmatta 😅