Defining categories from comments data

[Anonymous]

Hello. I have a data that contains comments from user for example:

1. The price is too high
2. Not suitable for my house
3. High price
4. The price is too expensive, other store offer lower price

5. The products is faulty

6. the products quality is bad

7. The price is too high and it's not suitable for my house

I'm trying to categorize the reason into a new columns called 'Categories'. The data will be for example: High Price, Quality Issues, Suitability Issues and such. I have used the IFERROR but it's not that efficient 

Price =

IF (
IFERROR ( SEARCH ( "pric", 'data'[comments] ), 0 )=0, BLANK(), "Price")

and for example the no 7 comment "The price is too high and it's not suitable for my house" has 2 reason which is High Price and Suitability.

Does anyone know how can I do this more efficiently? Thank you in advance.

btw my data is in csv format. 

[v-cherch-msft · Accepted solution]

Hi @Anonymous

I would suggest  you may create a table2 as below. Then you may create the calculated column with CONCATENATEX Function. Here is the similar post for your reference.

Column =
CONCATENATEX (
    FILTER ( Table2, SEARCH ( Table2[Key], Table1[comment], 1, -1 ) > 0 ),
    Table2[Category],
    " and "
)

Regards,

Cherie

[Anonymous]

Thank you for your help! I'll try them

[Ashish_Mathur]

Hi,

See if my solution here helps - Search for multiple phrases within a cell and extract all those phrases in another column.

Hope this helps.

[Anonymous]

Thank you for your help!