Forum Discussion
combine two columns in one
#"Merged Queries" = Table.NestedJoin(#"Replaced Value", {"Country"}, Table, {"Country_short"}, "Table", JoinKind.LeftOuter),
#"Expanded Table1" = Table.ExpandTableColumn(#"Merged Queries", "Table", {"Company", "Country"}, {"Table.Company", "Table.Country"})
How do I combine those two column in #'Expanded Table1'? In the end i want to have on string in one column like. Company & "(" & Country & ")"
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
1 Reply
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