Append data with different column names by Union tool in Alteryx

As part of this recipe, we will see how to append data that has different column names using the Union tool in Alteryx

Recipe Objective: How to append the data having different column names by Union 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 "Union data-diff column name" sheet, Select the range as "Range5," and click on Ok.

FastText and Word2Vec Word Embeddings Python Implementation

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 "Range6", then click the run button so that we will have two Input data tools. Then drag the Union tool from the Join tab and connect it with the two INPUT DATA tools in the New workflow.

Step 6:

Then go to the configuration pane/window, select the option "Auto Config by Position."Now click on the Run button to view the results workflow. As in this case, the field/column names are different, but the data can be appended.

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

Build a Credit Default Risk Prediction Model with LightGBM
In this Machine Learning Project, you will build a classification model for default prediction with LightGBM.

MLOps Project to Build Search Relevancy Algorithm with SBERT
In this MLOps SBERT project you will learn to build and deploy an accurate and scalable search algorithm on AWS using SBERT and ANNOY to enhance search relevancy in news articles.

Topic modelling using Kmeans clustering to group customer reviews
In this Kmeans clustering machine learning project, you will perform topic modelling in order to group customer reviews based on recurring patterns.

MLOps using Azure Devops to Deploy a Classification Model
In this MLOps Azure project, you will learn how to deploy a classification machine learning model to predict the customer's license status on Azure through scalable CI/CD ML pipelines.

Digit Recognition using CNN for MNIST Dataset in Python
In this deep learning project, you will build a convolutional neural network using MNIST dataset for handwritten digit recognition.

AWS MLOps Project to Deploy a Classification Model [Banking]
In this AWS MLOps project, you will learn how to deploy a classification model using Flask on AWS.

Build CI/CD Pipeline for Machine Learning Projects using Jenkins
In this project, you will learn how to create a CI/CD pipeline for a search engine application using Jenkins.

Credit Card Fraud Detection as a Classification Problem
In this data science project, we will predict the credit card fraud in the transactional dataset using some of the predictive models.

Predict Churn for a Telecom company using Logistic Regression
Machine Learning Project in R- Predict the customer churn of telecom sector and find out the key drivers that lead to churn. Learn how the logistic regression model using R can be used to identify the customer churn in telecom dataset.

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.