Create a new column from a list of keywords and a project summary

[Viviane]

Hello,

I have a main table "Projects" with project summaries and a "Keyword" table with a list of keywords. I would like to create a new column in my "Projects" table by putting the keywords present in the project summaries.

For example:

If I have a project summary containing the word aviation, fishing, dune and these three words are part of my "Keyword" table, then QlikSense will add aviation, fishing and dune in my "Keyword" column. This will allow me to make a tagcloud according to the recurrence of the keywords.

Thanks in advance,

Viviane

Translated with www.DeepL.com/Translator (free version)

[rwunderlich · Accepted solution]

Take a look at this downloadable example.

Qlikview Cookbook: Indexing Keywords in Text https://qlikviewcookbook.com/recipes/download-info/indexing-keywords-in-text/

-Rob

[Viviane]

Thank you very much Rob, it's perfectly works with my case 😃

have a good day,

Viviane