Concatenate Two Columns & Override Data in Third Existing Column

[Leanna12]

Description of Process	Concatenate output from two columns and override the data in an existing column.  In excel, I would use the "&" function
Description of Input	MM DD YY INITIALS V 2 Note Updates [07 MAR 23 LMW] Decomm in Progress [07 MAR 23 LMW] Decomm in Progress
Description of Output (DESIRED OUTPUT)	MM DD YY INITIALS V 2 Note Updates NOTES [07 MAR 23 LMW] Decomm in Progress [07 MAR 23 LMW] Decomm in Progress [07 MAR 23 LMW] Decomm in Progress [07 MAR 23 LMW] Decomm in Progress
Error Message  -Copy	None - Did not run anything yet
Copy of the Input Data (truncated) within the flow	See above
Alteryx Version	Alteryx Designer 2021.4

[kathleenmonks · Accepted solution]

HI @Leanna12 

In order to do this, you should use the Formula tool with the equation:

[MM DD YY INITIALS V 2] + " " + [Note Updates] 

This is assuming those are the column names. The name of your new column will be NOTES. The " " part is only necessary if you want a space between the two values in your output.

[Leanna12]

That worked perfectly! Thanks Kathleen :-)