Count of concatenated value

[Cheshta22]

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.

[binuacs · Accepted solution]

@Cheshta22 One way of doing this

[CWG0816]

Hi Cheshta22,

So long as there is a space after the commas you can use the CountWords formula. See the attached example. 

[Martyn · Accepted solution]

Formula Tool with....

REGEX_CountMatches([Concatenated],",") + 1

[CharlieS · Accepted solution]

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

[Cheshta22]

Thank you :)

[RobertOdera]

Hi, @Cheshta22 

Try the below.

I hope you find it helpful - cheers!