Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Word count

Jackmcc26
6 - Meteoroid
‎09-14-2021 06:26 AM

Hi all, working on a dataset currently, I am wanting to find (within 1 column) which fields have 5 words or more within them. There are 1500 rows altogether. But yes i am wanting to find those with 5 words or more. How would i do this? 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
bensilv
Alteryx Alumni (Retired)
‎09-14-2021 06:41 AM

Hi @Jackmcc26 , what you're looking for is a formula tool (followed by a filter) using the CountWords() function.

 

See the attached workflow

 

bensilv_0-1631626878735.png

 

Wordcount.yxmd
Reply
0 Likes
Jackmcc26
6 - Meteoroid
‎09-14-2021 06:57 AM

Appreciate the quick responses!

Reply
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels