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.
¡Resuelto! Ir a solución.
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
Thank you :)