Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Counting items in a cell

I have imported an excel table into Alteryx for further use in Tableau. I need to count the number of items (delimited by ; ) in a cell. How can I do this?

Thank you!

2 REPLIES 2
AdamR_AYX
Alteryx Alumni (Retired)
If you just need a count then I think this formula will give you that

REGEX_CountMatches([Field1], ";") + 1

If you actually wanted to split the items into individual cells then I'd take look at the "Text To Columns" tool in "Split to Rows" mode.

Cheers
Adam
Adam Riley
https://www.linkedin.com/in/adriley/
Thanks!
Labels
Top Solution Authors