Creating the reference category column with the words in the texts in the data list

Hi everyone

I’m trying to add a category column to the data table and add the categories to the rows. But the rows in the data set can match many categories.

If a data row matches more than one category, both categories must be added to the same reference category column so that the matching categories are not lost. So I cannot proceed as a single category, the category code column to be added must be single and the matching codes must be in the same column in the same row… but how do I do it?

Also reference code list +8000 code

How can I do it? Can you add me a sample simple workflow?

I’m not looking for an exact match between the reference column and the data, so all words of a reference value in the reference column don’t have to be in the data table. If any word in the data list matches in a matching line in the reference code list, it should be added to the code column, that is, the code should be added in the relevant line.