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":
| id | words |
| 101422396593387_27005 | super |
| 101422396593387_27005 | gorgeous |
| 101422396593387_27005 | gt |
| 101422396593387_27005 | lt |
| 1022527897877203_1039105649552761 | connect |
| 1022527897877203_1039105649552761 | with |
| 1022527897877203_1039105649552761 | us |
| 1022527897877203_1039105649552761 | on |
| 1022527897877203_1039105649552761 | linkedin |
| 1022527897877203_1039105649552761 | be |
| 1022527897877203_1039105649552761 | a |
| 1022527897877203_1039105649552761 | part |
| 1022527897877203_1039105649552761 | of |
| 1022527897877203_1039105649552761 | our |
| 1022527897877203_1039105649552761 | professional |
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 |
