It is very easy to concatenate in Alteryx using the Formula tool. Here’s a short guide on how to do it:
- 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.
- 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.
- Next, tap the formula field and type "[".
- Subsequently, select the first column you wish to use.
- Type the 'Plus' (+) sign symbol afterwards.
- Once again, type "[" as the continuation of the formula.
- Select the next field you wish to use.
- Wait patiently while your input is being processed.
- Finally, the data from the selected fields in your Alteryx workflow will be concatenated according to your input.
