topic parsing columns in App Development

parsing columns

ali_hijazi — Tue, 16 Jan 2018 11:19:55 GMT

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

marcus_sommer — Tue, 16 Jan 2018 13:29:38 GMT

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

= subfield(

subfield(

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

chr(10) , 1),

'|', 2)

- Marcus

ali_hijazi — Wed, 17 Jan 2018 14:56:18 GMT

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