Community Conundrums are live! Learn more

Concatenate two string columns

Level 1
Concatenate two string columns
Jump to solution
Is there a built-in function or custom formula that I can use to concatenate two string columns together?
0 Kudos
3 Replies
Dataiker
Dataiker
Yes, in a preparation script, there is a processor called "concatenate columns".
0 Kudos
Dataiker
Dataiker
You can also use the "custom formula" editor to concatenate columns, by using the following syntax :
Column_Name1 + Column_Name2 + " - " + Column_Name3
DSS Fanboy
0 Kudos
Level 1
Author
Ok, I see it now. I had gone into the "custom formula" editor for one of the columns I wanted to concatenate and didn't see the processor there. I do see it when I just click the "Add a step manually" button from the script editor on the left-hand side of the screen.

Thanks!
0 Kudos
Labels (3)