Mapping Many Keywords

[patri0t82]

Hello,

I'm trying to get out ahead of a problem for a solution I'm working on. There is a large table, say, 1000 rows. I need to search a column for multiple keywords and assign a category. 

I guess normally on a smaller scale I would add a Conditional Column in PQ and simply do it like that, but where there are going to be a good many variables, it doesn't really seem feasible.

Can someone point me to a resource, or perhaps offer a good way of going about this?

[Anonymous]

Hi  @patri0t82 ,

Did you solve your problem, if so, you can Mark the correct answer, if not, you can provide screenshots of the results you want and we can help you better.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[patri0t82 · Accepted solution]

Ah, as a follow up, I see v-stephen-msft has a solution here that could potentially help: https://community.powerbi.com/t5/Power-Query/Checking-keywords-from-another-table/m-p/2669113 

I'll try this, but if anyone else has any ideas I'd greatly appreciate them.