2 Replies Latest reply: Jan 17, 2018 9:56 AM by Ali Hijazi RSS

    parsing columns

    Ali Hijazi

      Hello

      got a table as shown in the attached excel file

      there is a column called extra: it contains the possible options for a drop down list

      can Qlik parse this via a wizard or I need to use string functions to get the required data?

      for example in the attached excel, the first line corresponds to Domain data family and the answer is 6 and 6 corresponds to Financial Transaction

      the possible values are saved in the column named extra

        • Re: parsing columns
          Marcus Sommer

          I think it could be done with rather simple string-operations like:

           

          = subfield(

               subfield(

                 mid(extra, index(extra, answer & '|')),

               chr(10) , 1),

              '|', 2)

           

          - Marcus

            • Re: parsing columns
              Ali Hijazi

              you know I was looking for the n value in chr(n)

              in qlik sense values appear on one line, when I export values to excel every line displays on new line so the delimiter turned out to be chr(10)

              and this solved my issue

              I will mark your answer as correct to close the discussion