In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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