Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dennisloos
New Contributor

Extract string matches from text

I have a list "keywords" as a filter chart on my dashboard with words to search through a dataset. Let's say this list contains these words:

keywords
super
gorgeous
professional
horrible
worst

I have a dataset with unnested words into a vector and I would like to loop through this dataset to check if one or more of the selected "keywords" match a word from unnested words. The words are grouped by id. I know how to do this in R, but I'm quite new to Qlik Sense and the syntax and my organisation requires this in Qlik Sense.

Let's say this dataset is called "Words":

idwords
101422396593387_27005super
101422396593387_27005gorgeous
101422396593387_27005gt
101422396593387_27005lt
1022527897877203_1039105649552761connect
1022527897877203_1039105649552761with
1022527897877203_1039105649552761us
1022527897877203_1039105649552761on
1022527897877203_1039105649552761linkedin
1022527897877203_1039105649552761be
1022527897877203_1039105649552761a
1022527897877203_1039105649552761part
1022527897877203_1039105649552761of
1022527897877203_1039105649552761our
1022527897877203_1039105649552761professional

In pseudo code it should be something like:

for word in length(Words):

     if words contains keywords[]:

          append(table.ID, keyword.id)

The output that I wish to get is:

Selected keywords:

keywords
super
gorgeous
professional

Table output:

ID
101422396593387_27005
1022527897877203_1039105649552761
1 Reply
ogautier62
Valued Contributor II

Re: Extract string matches from text

Hi,

something like this should works :

inner join (keywords) load keyword as words,id resident Words;

regards