Here is my data: NumbersSKUs12345685458123456548473123456465431212345616854778910549784789105456477891054677324 Here is what I want: NumbersSKUs12345685458,548473,4654312,16854778910549784,5647,677324 Take out the duplicate "numbers" column to make the SKUs column all comma separated. THANK YOU!

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

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!

Help

Accepted answers

IraWatt

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

Workflow.yxmd

All comments

MilindG

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

Conc_Sample.yxmd

IraWatt

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

Workflow.yxmd

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 !

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703