This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.