Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Grouping column values with a delimiter based on another column value

I have a table in below format:   API 1 one API 1 two API 1 three API 2 four API 2 five API 3 six API 3 seven   We want to create another table where, we want to gr...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    You can try below code:-

    Table 2 = 
SUMMARIZE (
    'Table (2)',
    'Table (2)'[Column1],
    "Concated", CONCATENATEX ( VALUES ( 'Table (2)'[Column2] ), [Column2], ";" )
)

     

    Output:-

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous ,

 

You can try below code:-

Table 2 = 
SUMMARIZE (
    'Table (2)',
    'Table (2)'[Column1],
    "Concated", CONCATENATEX ( VALUES ( 'Table (2)'[Column2] ), [Column2], ";" )
)

 

Output:-

 

Thanks,

Samarth