How to make one column comma separated based on duplicates of another

[AllTheQuestions]

Here is my data:

Numbers	SKUs
123456	85458
123456	548473
123456	4654312
123456	168547
7891054	9784
7891054	5647
7891054	677324

Here is what I want:

Numbers	SKUs
123456	85458,548473,4654312,168547
7891054	9784,5647,677324

Take out the duplicate "numbers" column to make the SKUs column all comma separated.

THANK YOU! 

[MilindG]

You will need to change the data type. Check out the attached workflow.

[IraWatt · Accepted solution]

Hey @AllTheQuestions,

You can take out the duplicates by grouping on both columns in a summarize tool. Then using the Summarize tools concatenate function you can create your output:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[DanielG]

@AllTheQuestions  -- Just use a Summarize Tool where you group by the Number Column and Concatenate the SKUs.  If the SKUs are of a numeric data type, you can just convert it to a string via a Select Tool before summarizing.   Hope this helps.  😀  

[IraWatt]

@DanielG I like the l lavender workflow canvas colour 😄! Hope your supporting the Dark Mode - Alteryx Community idea on the community to give more colouring options for Designer.

[DanielG]

@IraWatt  -- thanks.  I needed tranquil color, as my data usually drives me nuts.  Helps balance things out.  haha.  I added a Like to the Ideas page.  Hopefully that is something they can accomplish.  

[AllTheQuestions]

@IraWatt thank you!  I did not know concatenate was an option like this!!  so helpful!

[IraWatt]

No worries @AllTheQuestions 😄 have a good one !