Add Column with blocks of text and columns values more than once

[rflora]

Hey folks,

I am trying to add a column that concatenates more than one piece of text with columns. I tried the following but it is not workin:

="This is a text example with the column" & [Column 1] & "and" & [Column 2] & "it is not working"

DataSource.Error: PostgreSQL: 42883: operator does not exist: text + unknown
Details:
DataSourceKind=PostgreSQL
DataSourcePath=*****
Message=42883: operator does not exist: text + unknown
ErrorCode=-2147467259

Much appreciated for any help!

Thanks!

[mahoneypat · Accepted solution]

Looks like you need to convert one or both of your columns to type text, then your formula should work.  Or you can wrap one/both in Text.From( ).

Regards,

Pat

[rflora]

Text.From() made it work. I was tired already :). Thanks a lot!