Extract word from a list in a field

[KKTOES]

Hi everyone, I'm new to Qliksense

I try to extract some specific word in a list, but I don't get the good result, maybe you will have response

field name : S

Id1              [A,B]

id2               [B,C]

id3               [C,A,D]

id4              [D]

I would like to have that result :

       S

id1 A

Id1 B

id2 B

Id2 C

etc.....

I tried to use subfield and Wilmatch  like this : 

If( WildMatch(S,'A'),subfield(S, ',' ,1),

   If( WildMatch(S,'B'),subfield(S, ',' ,1),

      If( WildMatch(S,'C'),subfield(S, ',' ,1)  as NewField

Have you an idea ?

Thank you

[marcus_sommer · Accepted solution]

Try it with:

subfield(purgechar(S, '[]'), ',') as NewField

Without specifying a third parameter in subfield() Qlik will loop through the list and create a new record for each item.

- Marcus

[KKTOES]

Thank you really much, it works

[KKTOES]

thanks you really much, easier than I expected and it works