Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.
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