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!
Solved! Go to 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
@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. 😀
@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.
@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.
@IraWatt thank you! I did not know concatenate was an option like this!! so helpful!
No worries @AllTheQuestions 😄 have a good one !