I have a table with item description ( written by sales teams in a free text format) and a separate table with item categories. I have over 50000 items and need to assign them a category (there is around 150 categories) - the majority if the description contain the category within the text. I need a formula that say if contain category in string then category. The contain formula allow me to check category one by one but I would like to have somethung that check all.
In my opinion, it would be easier to do this during the data prep stage prior either by using database or tools like Alteryx.