Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Concatenation of rows for column

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.

 

Need Help
Show and Tell
Tutorial Requests
  • jpessoa8's avatar
    jpessoa8
    2 years ago

    Hello Anonymous,

     

    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

3 Replies

  • jpessoa8's avatar
    jpessoa8
    Icon for Continued Contributor rankContinued Contributor
    2 years ago

    Hello Anonymous,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks for your responce.

       

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

       

       

       

      • jpessoa8's avatar
        jpessoa8
        Icon for Continued Contributor rankContinued Contributor
        2 years ago

        Hi Anonymous,

         

        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