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 |
