It is very easy to use the Join tool in Alteryx. Here’s a short tutorial on how to do it in simple steps:
- Inside Alteryx's workflow designer, go to the left-side panel and find 'Join'. Drag this tool onto the canvas for further configuration.
- After that, hold the output anchor of the first Input Data tool and drag it onto the input anchor (L) of the Join tool.
- Likewise, hold the output anchor of the second Input Data tool and drag it onto the other input anchor (R) of the Join tool
- Click the Join tool to make your desired configurations.
- To get started, go to the Join Options section in the right-hand panel and choose one from the list of choices.
- Subsequently, configure the corresponding settings. Depending on your chosen join options, you may need to specify either the columns or the positions of the records.
- Finalize the list of columns you want to show, along with their respective positions.
- After completing these steps, the Join tool will process your data and combine it according to your inputs.
