Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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 con...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago
    Text.From([Column) & Text.From([Column2]) & Text.From([Column3])
Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

A Sample:

=[Segment] & Text.From([Count])

 

 

If you column is not a string use Text.From([Column]) else just the column name

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Vvelarde

     

    in my chance all the columns are of type int, as would be?

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      10 years ago
      Text.From([Column) & Text.From([Column2]) & Text.From([Column3])
      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Vvelarde

        taking advantage, I have a date field that is in the format (dd / mm / yyyy hrs) and need to create a custom column from that field that presents only the yyyy, tried some string functions however nothing.

  • puraskar_award's avatar
    puraskar_award
    Frequent Visitor
    6 years ago

    Thanks for explaining why to use Text.From()