Concatenate values in a row for the already concatenated values in another row

[WTAS80486]

HI,

I have a Column A in a table A

Column A

ABC, DEF

And two other columns B and  C in another Table B in power BI is 

Column B	Column C
ABC	OO
DEF	PP

What i wanted to display in table A is

Column A	Column D
ABC, DEF	OO,PP

[WTAS80486]

Thanks @v-jingzhang 

[v-jingzhang · Accepted solution]

Hi @WTAS80486 

You can add a custom column with below code in Table A. 

Text.Combine(
    List.Combine(
        List.Transform(
            Splitter.SplitTextByDelimiter(",")([Column A]),
            each let pColumnA = _ in Table.SelectRows(#"Table B", each [Column B] = pColumnA)[Column C]
        )
    ), 
    ","
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.