Group By Function
- 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 may I check is there a way to sort the data in Alteryx by Group By function without using the summarise tool function?
Thanks.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@dhakim1996, you can try the Tile tool. It depends on the use case that you are trying to resolve.
Ultimately in order to achieve aggregation you will have to use summarize tool.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dhakim1996.
@grazitti_sapna has a great suggestion using the Tile tool.
If you haven't already, you may also want to look into the Crosstab and Transpose tools under the Transform category. You can often perform stronger summarisations and group by like processes when using these over the Summarise tool. If you haven't already, I'd check out the tool examples in Designer which showcase a great example of how you can perform group bys with these tools.
Best,
Chris Clark
Alteryx Solutions Engineer
