Text Analysis

[poojamate92]

Hello,

I'm new to Alteryx and I have a task to do text analysis. I have a list of complaints  (Field_6 in the Test2 data)  in which I have to do bucketing on which complaint fall in which type given in the second table's field and based on that I have to count  highest complaint rate.

Please find the below attachment and suggest me how Can I do this.

Thanking you In Anticipation 

[SeanAdams · Accepted solution]

Hey there @poojamate92

This seems to be the same task as one of the weekly challenges - and quite a few people have solved this on that thread.

Take a look here, there's a few options for you to choose from:

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-11-Identify-Logical-Groups/td-p/36739