Apply Map to comma separated values?

[CasperQlik]

I need help with decoding ID's in a string.

I have a dataset that looks like this:

name	relationships
IT	10, 30, 21, 87
HR	87
Accounting	11, 7

I need to translate the relationship codes into department names. For this purpose I have created a Mapping Table.

I understand how to apply the table if my field only contained 1 single value always. But I don't know how to use the Mapping Load when I would like to "translate" multiple values in a string separated by commas. The result should be something like this.

name	relationships
IT	Lab, Kem, Stu, Accounting
HR	Accountring
Accounting	ADM, IT

[tresesco · Accepted solution]

Qlik has a function for you too MapSubstring - script function | QlikView Help 😋

[CasperQlik]

Yes! Just what I was looking for! Thank you 🙂