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.
@Cheshta22 One way of doing this
Formula Tool with....
REGEX_CountMatches([Concatenated],",") + 1
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
Hi Cheshta22,
So long as there is a space after the commas you can use the CountWords formula. See the attached example.
Thank you
Hi, @Cheshta22
Try the below.
I hope you find it helpful - cheers!
