Dears,
I have 2 string fields, one contains a "formal responses approved by the organization to be used by customer service reps", and the other contains "the real responses by reps"..
What I wanna do is to have a function to find if the real responses match any of the formal responses.. the goal is to assess the compliance of the employees with the formal responses..
any idea if there is a function or tool that compares the 2 texts on a %, for example see if the 2 texts are the same by 90% of words..
any idea how can I do that?
Hello,
I'm not aware of a out-of-the box solution for this but a little workflow should solve this:
You might also consider the Text Preprocessing from our intelligence suite add-on which enables you to sort out stop words (a, and, so, like, etc.) automatically: https://www.alteryx.com/products/alteryx-platform/intelligence-suite
Pls. see example WF attached.
If this solves your question, please mark the solution as accepted as it helps Alteryx to determine the correct statistics about open and solved cases.
Thank you!
Cheers
Matthias
Thank you for your help i will try it,
also I'm thinking of using Fuzzy Match tool, but its my first time to use it and IDK how to use it
Thank you for your help i will try it,
also I'm thinking of using Fuzzy Match tool, but its my first time to use it and IDK how to use it
Hi @refmd - If you're interesting in learning Fuzzy Matching, you can watch the following videos: