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 1Column 2Column 3Joe8/2/2010SmithSteve8/25/2008PerrySue1/4/2010ParsonsPeter1/25/2021PiperRalph10/22/2000Machio 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??? Example1.xlsx

Concatenate 3 Columns into ONE NEW COLUMN

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???

Example1.xlsx

Transformation

Accepted answers

michelle_mathews

@Adam_B , thanks for attaching some data. I looked at it and it seems Alteryx doesn't like the square brackets in the column names. I used a Dynamic Rename tool to remove the ' [ ' and ' ] ' characters. Alternatively, you could have renamed the fields in the Select tool so that they didn't have the brackets. Hope this helps!