How concat 2 columns in dataset?

[Philippe_Reaud]

Hi all,
how are you ?

CMS Version

3.3.0

Issue

I’m trying to concat 2 columns in dataset with formula type column.
I tried CONCAT(column1, column2) but i’m facing to an invalid error formula message.

Is anybody knoww how to concat 2 columns in dataset ?
Best regards,
Philippe

[pitoco02]

I had the same problem with some formulas in the dataset…
What I did was access the database directly, and put my formula directly in the formula column.
And it works

[203]

You need to use backticks (`) so

CONCAT(Column 1, Column 2)

[203]

@203

You need to use backticks (`) so

CONCAT(`Column 1`,`Column 2`)

Seems the forum ate the actual back ticks in the example, so just for clarity for future readers…