Merging multiple columns into one.

[Dan_Alteryx1]

Hello,

I have 3 columns containing data type V_String, and I want to merge these 3 columns into 1. See below for an example of how I want to manipulate the data.

Before:

Column1	Column2	Column3
5632	14	C
6789	15	D
9078	14	A

After:

NewColumn

563214C

678915D

907814A

It looks like I should use the Formula tool, but I am not sure how. Any help would be greatly appreciated.

Thanks!

[AJKENDALL95 · Accepted solution]

Hi draskay

The most straightforward approach here will be to add in a formula tool to create a new column, with the formula [Column1] + [Column2] + [Column3].

Thanks!