Alteryx Designer Desktop Discussions

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

Quick grouping question

sampson
6 - Meteoroid

This is probably a quicky question for many of you. Smiley Happy  

 

I'm trying to group some data and I'm unsure about how to do it.  Below is an oversimplified example but I've attached a more in depth example csv as well.

 

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
You can use the summarize tool and group by employee_id. Then choose the concatenation function for the job number and use a space as the delimiter.

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
sampson
6 - Meteoroid

That seems to be moving me in the right direction but can you expand a bit?  How do I use that for the job number?

 

EDIT:  I just needed to read your response a little closer.  Got it!  Thank you!

Labels