Trying to achieve the equivalent to a group_concat() in SQL ... help !
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi ! I'm relatively new to Alteryx, but starting to get the feel how to think in an "Alteryd" way. However, I'm struggling to wrap my head around the way to approach this one thing I can easily conceptualise in SQL and have not had much luck looking for leads on the site. If anyone can point me to the right direction, I would appreciate. Have attached a pictorial that illustrates what I'm starting with and what I want to accomplish.
In SQL, I would say that I'm trying to do the equivalent of a select statement that uses a group_concat() function in the select portion of the statement. Can't for the life of me think of how to achieve this in Alteryx. Help !
Thanks,
8088.
Solved! Go to Solution.
- Labels:
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I've attached a packaged workflow that shows a really quick example of this. I'm using a dataset posted by a different community user, so I forced a number to be a string for this exercise.
Basically, the Summarize tool will allow you to specify a GROUP BY on certain fields, as well as a concatenation of others.
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
