Forum

Combine or Concaten...
 
Notifications
Clear all

Combine or Concatenate Column with Text String

2 Posts
2 Users
0 Reactions
92 Views
(@raffrobb)
Posts: 38
Trusted Member
Topic starter
 

Hi all:

 

I am getting errors on combining [Sweep Count] & "Day".

[Sweep Count] column is a number from 2 to 7.  I want my custom column to display 2 Day ...7 Day

Its driving me crazy, nothing seems work. 

Thanks

RobbColumn-text-string.png

 
Posted : 03/02/2021 3:56 am
(@catalinb)
Posts: 1937
Member Admin
 

Most probably, the error says something like: "Cannot combine text and numbers"
You have to make sure the data type is the same (text), basically this is what it means...
Text.From([Sweep Count]) & "Day"

 
Posted : 03/02/2021 4:11 am
Share: