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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Work flow Help to find key phrases in customer responses

Atom

I am trying to create a workflow through large sets of customer responses looking for product conditions which created the complaint or tech inquiry. I need to be able to account for misspelling and varied terms used by both customers and technicians.  I am new to alteryx and not sure how to start building this work flow.  Where/how should I start?

Alteryx Partner

Hi,


There is no simple answer here. And it's very dependent on the data source/fields that you have.

 

Assuming you have verbatim text, I would look to parse each word out of the text, cleanse it and then try to match it to a dictionary of accepted terms. Once matched (you can use the find/replace tool) you can then put the words on one line again. Neat trick here is to use "Concatenate" in a group by - example below.

 

Also attaching a solution example for you.

 

Regards,

Tom

 

Concatenate example.jpg

Labels