comma seperated ids - convert to names based on a mapping from a different table

[vishalcmehta]

Hi,

I have a Table A, which lists comma seperated ids. In a seperate Table B, we have a mapping between ID and app names. Is there a way I can convert comma seperated ids into app names as shown in the expected output below?

Table A:

seqNum	appID
a	2,3
b	1
c	1,3,4

Table B:

appID	appName
1	yahoo
2	google
3	hotmail
4	outlook

Expected Output:

Table A

seqNum	appID	appName
a	2,3	google,hotmail
b	1	yahoo
c	1,3,4	yahoo,hotmail,outlook

[v-deddai1-msft]

Hi @vishalcmehta ,

Additional to camargos88's reply, please refer to Concatenate, Merge or Combine multiple rows into one value - Power Query for Power BI

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[camargos88 · Accepted solution]

Hi @vishalcmehta ,

I've created this file as an example: Download PBIX 

I hope it helps,

If you consider it as a solution, please mark as a solution and kudos.

Ricardo