Concatenate Two Columns & Override Data in Third Existing Column

Question

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

Concatenate Sample Workflow.yxmd

Concatenate Sample.xlsx

kathleenmonks · Accepted Answer

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.