1 Reply Latest reply: Jun 15, 2018 3:24 AM by Olivier GAUTIER RSS

    Extract string matches from text

    Dennis Loos

      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