Concatenate 3 Columns into ONE NEW COLUMN

[Adam_B]

Hello, 

I have searched through the discussion boards and I am not finding help on one issue I have.  I have to create a NEW Column named "NewCOLUMN", in that column I would like to use 3 columns information, separated by a comma.  Attached is a copy of the data.  

Column 1	Column 2	Column 3
Joe	8/2/2010	Smith
Steve	8/25/2008	Perry
Sue	1/4/2010	Parsons
Peter	1/25/2021	Piper
Ralph	10/22/2000	Machio

I would like NewCOLUMN to show Row 1 as: 

Joe,02/08/2010,Smith

I can do this in Excel with a concatenate formula as CONCAT(A2,",",TEXT(B2,"dd/mm/yyyy"),",",C2)

But how do I do this in Alteryx???

[michelle_mathews]

@Adam_B , you can use the following expression in the formula tool: [Column 1]+","+[Column 2]+","+[Column 3]

[Adam_B]

@michelle_mathews So this is the error I am getting. 

[michelle_mathews]

@Adam_B , looks like you have extra square brackets in there. Each column name should be enclosed by single square brackets like this [Column Name]

[binuacs]

@Adam_B One way of dong this

[Adam_B]

@michelle_mathews the raw data has the column name with a Bracket, so when I chose it, it comes into the formula

[michelle_mathews]

@Adam_B , gotcha. Are all 3 columns string? Trying using a Select to ensure that date field is a string before concatenating. Alternatively, another user posted an example on how to account for that within the formula. 

[Adam_B]

@michelle_mathews  Not sure what mean by Select, as in the preparation tool? 

[michelle_mathews]

@Adam_B , yes. Attaching an example 

[Adam_B]

@binuacs I am getting this parse error