community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Identifying Common Words in a String Field

Meteor

I have a list of about 300 project names. I would like to analyze the project names to determine common words, for example "Lotion" may be contained in 25 of the project names. Since it is a small list, I can do this manually, but it would be great if alteryx could help me out. Any thoughts on ways to do this analysis using alteryx?

Alteryx Certified Partner
Alteryx Certified Partner

I've attached one potential solution to this reply.

 

The overview is to get all of your project names in Alteryx and parse them into individual words. Then those words can be counted and quantified however you'd like. I applied the uppercase( function to account for differences in capitalization between records.

 

Labels