Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
Concatenate function with "Sort" option
Status:
Accepting Votes
Submitted by
Matthew
on
‎10-19-2021
06:21 AM
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
I often need to concatenate and sort strings that are on the same row.. Currently, the only way to do this in Alteryx is by transposing each string onto a separate row, sorting the rows, then summarising them back together.
I would love a new function in the Formula tool to concatenate strings. This function could allow you to choose a sort order (or no sort), and allow you to choose the concatenation separator
Concatenate("SortAscending",",",[Field1],[Field2],...)
See more ideas labeled with:
2 Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.