What is the use of the Join tool in Alteryx

This recipe explains what is the use of the Join tool in Alteryx

Recipe Objective: What is the use of the Join tool in Alteryx?

Step 1:

Open Alteryx Designer software. Here New workflow1 is by default available.

Step 2:

Now go to the Favorite tab or IN/OUT tab, where we can see a tool named "INPUT DATA."

Step 3:

Drag the INPUT DATA tool on the below side in the New Workflow1. Now go to the Configuration pane/window and click on the drop-down available to connect a file or database.

Step 4:

After this, it will redirect us to the data connection window, here we have to click on the files option, then click on the select file option, and ask us to select a file from the folder. Here we have chosen a file named "Sales 2017-Copy". Then select the "Join Data" sheet; select the range as "Range7," and click on Ok.

Step 5:

Then click on the Run button or press CTRL+R. In the results workflow, data will be displayed. Then right-click on Input Data tool and click on copy, now paste the same in the New workflow, now go to the configuration pane/window and in the Table or Query option select range as "Range8", then click the run button so that we will have two Input data tools. Then drag the Join tool from the Join tab and connect it with the two INPUT DATA tools in the New workflow.

Step 6:

Connect the two Input data tools to the "L" and "R" (Left and Right), input anchor of the Join tool, Then go to the configuration pane/window, select the option as "Join by Record Position." Now click on the Run button to view the results workflow and click on the "J" output anchor (Join) to view the joined data.

What Users are saying..

profile image

Anand Kumpatla

Sr Data Scientist @ Doubleslash Software Solutions Pvt Ltd
linkedin profile url

ProjectPro is a unique platform and helps many people in the industry to solve real-life problems with a step-by-step walkthrough of projects. A platform with some fantastic resources to gain... Read More

Relevant Projects

Classification Projects on Machine Learning for Beginners - 2
Learn to implement various ensemble techniques to predict license status for a given business.

Learn to Build Generative Models Using PyTorch Autoencoders
In this deep learning project, you will learn how to build a Generative Model using Autoencoders in PyTorch

CycleGAN Implementation for Image-To-Image Translation
In this GAN Deep Learning Project, you will learn how to build an image to image translation model in PyTorch with Cycle GAN.

Build a Similar Images Finder with Python, Keras, and Tensorflow
Build your own image similarity application using Python to search and find images of products that are similar to any given product. You will implement the K-Nearest Neighbor algorithm to find products with maximum similarity.

Build a Multi Touch Attribution Machine Learning Model in Python
Identifying the ROI on marketing campaigns is an essential KPI for any business. In this ML project, you will learn to build a Multi Touch Attribution Model in Python to identify the ROI of various marketing efforts and their impact on conversions or sales..

Build a Speech-Text Transcriptor with Nvidia Quartznet Model
In this Deep Learning Project, you will leverage transfer learning from Nvidia QuartzNet pre-trained models to develop a speech-to-text transcriptor.

Tensorflow Transfer Learning Model for Image Classification
Image Classification Project - Build an Image Classification Model on a Dataset of T-Shirt Images for Binary Classification

Linear Regression Model Project in Python for Beginners Part 2
Machine Learning Linear Regression Project for Beginners in Python to Build a Multiple Linear Regression Model on Soccer Player Dataset.

Classification Projects on Machine Learning for Beginners - 1
Classification ML Project for Beginners - A Hands-On Approach to Implementing Different Types of Classification Algorithms in Machine Learning for Predictive Modelling

Loan Eligibility Prediction Project using Machine learning on GCP
Loan Eligibility Prediction Project - Use SQL and Python to build a predictive model on GCP to determine whether an application requesting loan is eligible or not.