How to Concatenate in Alteryx

‍

It is very easy to concatenate in Alteryx using the Formula tool. Here’s a short guide on how to do it:

1. Inside Alteryx's workflow designer, head over to the left-side panel and find 'Formula'. Drag this tool onto the canvas and connect it to the Input Data tool or other sources.
2. After that, go to the right-hand panel and make the necessary configuration. To get started, enter your preferred name for the Output Column and then select its Field Type.
3. Next, tap the formula field and type "[".
4. Subsequently, select the first column you wish to use.
5. Type the 'Plus' (+) sign symbol afterwards.
6. Once again, type "[" as the continuation of the formula.
7. Select the next field you wish to use.
8. Wait patiently while your input is being processed.
9. Finally, the data from the selected fields in your Alteryx workflow will be concatenated according to your input.