Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Word count

Jackmcc26
6 - Meteoroid

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? 

2 REPLIES 2
bensilv
Alteryx
Alteryx

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

 

Jackmcc26
6 - Meteoroid

Appreciate the quick responses!

Labels