Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

combine two columns in one

  #"Merged Queries" = Table.NestedJoin(#"Replaced Value", {"Country"}, Table, {"Country_short"}, "Table", JoinKind.LeftOuter), #"Expanded Table1" = Table.ExpandTableColumn(#"Merged Queries", "Tabl...
Need Help
  • goncalogeraldes's avatar
    goncalogeraldes
    3 years ago

    Hi Anonymous! You can try the following M code:

     

    = Table.CombineColumns(#"Expanded Table1",{"Company", "Country"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Company - Country")

     

    Please note that I used " - " as a separator for the column so change it according to your needs!

     

    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 kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes

goncalogeraldes's avatar
goncalogeraldes
Super User
3 years ago

Hi Anonymous! You can try the following M code:

 

= Table.CombineColumns(#"Expanded Table1",{"Company", "Country"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Company - Country")

 

Please note that I used " - " as a separator for the column so change it according to your needs!

 

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 kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes