SOLVED
Count of concatenated value
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Cheshta22
6 - Meteoroid
‎03-22-2023
08:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Community.
Trying to figure out how to calculate the number of values in concatenated column.
Example:
Can someone help me with the alteryx please.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Developer
- In Database
- Tips and Tricks
6 REPLIES 6
binuacs
21 - Polaris
‎03-22-2023
08:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CWG0816
5 - Atom
‎03-22-2023
08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Martyn
9 - Comet
‎03-22-2023
08:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Formula Tool with....
REGEX_CountMatches([Concatenated],",") + 1
17 - Castor
‎03-22-2023
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Good solutions! Here's another: A Formula tool with this expression would count the number of commas in the string (then add 1 to give the count of arguments)
REGEX_CountMatches([Concatenated],",")+1
‎03-22-2023
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you :)
RobertOdera
13 - Pulsar
‎03-22-2023
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
