Concatenation of rows for column

[Bhaskarkolli9]

Hi All,

I am trying to create column based on available column.

Such as TDLINE ,TDNAME,Test desire result as below.

Requesting any posiblitities in M query please help.

Thanks in advance.

[jpessoa8 · Accepted solution]

Hello @Bhaskarkolli9,

This is possibile in PowerQuery by doing some adjustments inside a GroupBy option.

Grouping the information by TDNAME you can add a new Column using the Text.Combine function like : 

Table.Group(Source, {"TDNAME"}, {{"Desire Result", each Text.Combine([TDLINE],","), type nullable text}, {"All", each _, type table [TDNAME=nullable text, TDLINE=nullable text, Test=nullable text]}})

You can get in this link a PowerBI file with an example : https://we.tl/t-emzQC0kXFv

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Jorge Pessoa

[Bhaskarkolli9]

Thanks for your responce.

We still facing the issue like coulmn was not find, but we have column available in table.

[jpessoa8]

Hi @Bhaskarkolli9,

In the Table.Group function you're providing, you are not referencing the previous step (Added Items1), but the "Source" step (as you can see in the picture bellow):

Instead you should have this :

Table.Group(#"Added Items1", {"TDNAME"}, {{"Desire Result", each Text.Combine([TDLINE],","), type nullable text}, {"All", each _, type table [TDNAME=nullable text, TDLINE=nullable text, Test=nullable text]}})

For additional help, please @ me in your reply!

You can also check out my LinkedIn!

Best regards,
Jorge Pessoa