Forum Discussion
create custom column concatenated
I'm fumbling create a custom column in a table that has already been loaded, this column will be used to relate that table to another, however I am unable to create this custom column.
I need to concatenate all the fields that are in the picture, I do not know what function and how to use, can someone help me?
- Text.From([Column) & Text.From([Column2]) & Text.From([Column3])
10 Replies
A Sample:
=[Segment] & Text.From([Count])
If you column is not a string use Text.From([Column]) else just the column name
- Text.From([Column) & Text.From([Column2]) & Text.From([Column3])
Thanks for explaining why to use Text.From()
