Use join by specific fields function of join multiple tool in alteryx

With this recipe, we'll learn how to use the Join Multiple tool in Alteryx to join by specific fields

Recipe Objective: How to use the Join by specific fields function of the Join Multiple 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 Range as "R_1" 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 the Input Data tool and click on copy; now paste the same in the New workflow. Again, right-click on the Input Data tool and click on copy. Now paste the same in the New workflow. Go to the configuration pane/window, and in the Table or Query option, select range as "R_2" and "R_3" for the second and third input data tool, respectively. Then click the run button to have results workflow, so we have three Input data tools in New Workflow1. Then drag the Join Multiple tool from the Join tab and connect it with the three INPUT DATA tools in the New workflow.

Step 6:

Connect the three Input data tools to the input anchor of the Join Multiple tool, Then go to the configuration pane/window, select the option as "Join by Specific Fields," and choose the option as "Record no." from Input_#1, Input_#2 and Input_#3 respectively. Now click on the Run button to view the results workflow.

What Users are saying..

profile image

Abhinav Agarwal

Graduate Student at Northwestern University
linkedin profile url

I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More

Relevant Projects

Build an AI Chatbot from Scratch using Keras Sequential Model
In this NLP Project, you will learn how to build an AI Chatbot from Scratch using Keras Sequential Model.

Build an Image Classifier for Plant Species Identification
In this machine learning project, we will use binary leaf images and extracted features, including shape, margin, and texture to accurately identify plant species using different benchmark classification techniques.

House Price Prediction Project using Machine Learning in Python
Use the Zillow Zestimate Dataset to build a machine learning model for house price prediction.

MLOps AWS Project on Topic Modeling using Gunicorn Flask
In this project we will see the end-to-end machine learning development process to design, build and manage reproducible, testable, and evolvable machine learning models by using AWS

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..

End-to-End ML Model Monitoring using Airflow and Docker
In this MLOps Project, you will learn to build an end to end pipeline to monitor any changes in the predictive power of model or degradation of data.

AWS MLOps Project for Gaussian Process Time Series Modeling
MLOps Project to Build and Deploy a Gaussian Process Time Series Model in Python on AWS

Build a Face Recognition System in Python using FaceNet
In this deep learning project, you will build your own face recognition system in Python using OpenCV and FaceNet by extracting features from an image of a person's face.

NLP Project on LDA Topic Modelling Python using RACE Dataset
Use the RACE dataset to extract a dominant topic from each document and perform LDA topic modeling in python.

Build a Autoregressive and Moving Average Time Series Model
In this time series project, you will learn to build Autoregressive and Moving Average Time Series Models to forecast future readings, optimize performance, and harness the power of predictive analytics for sensor data.