Append the data by column position with Union tool in Alteryx

As part of this recipe, we'll see how to append data by column position with the Union tool in Alteryx

Recipe Objective: How to append the data by column position with 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 dropdown 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-posn append" sheet, Select the range as "Range3," and click on Ok.

Step 5:

Then click on 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 "Range4", 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.

What Users are saying..

profile image

Jingwei Li

Graduate Research assistance at Stony Brook University
linkedin profile url

ProjectPro is an awesome platform that helps me learn much hands-on industrial experience with a step-by-step walkthrough of projects. There are two primary paths to learn: Data Science and Big Data.... Read More

Relevant Projects

BigMart Sales Prediction ML Project in Python
The goal of the BigMart Sales Prediction ML project is to build and evaluate different predictive models and determine the sales of each product at a store.

Ola Bike Rides Request Demand Forecast
Given big data at taxi service (ride-hailing) i.e. OLA, you will learn multi-step time series forecasting and clustering with Mini-Batch K-means Algorithm on geospatial data to predict future ride requests for a particular region at a given time.

Learn to Build a Siamese Neural Network for Image Similarity
In this Deep Learning Project, you will learn how to build a siamese neural network with Keras and Tensorflow for Image Similarity.

Build a Collaborative Filtering Recommender System in Python
Use the Amazon Reviews/Ratings dataset of 2 Million records to build a recommender system using memory-based collaborative filtering in Python.

Insurance Pricing Forecast Using XGBoost Regressor
In this project, we are going to talk about insurance forecast by using linear and xgboost regression techniques.

Build an End-to-End AWS SageMaker Classification Model
MLOps on AWS SageMaker -Learn to Build an End-to-End Classification Model on SageMaker to predict a patient’s cause of death.

Deploying Machine Learning Models with Flask for Beginners
In this MLOps on GCP project you will learn to deploy a sales forecasting ML Model using Flask.

Build a Text Generator Model using Amazon SageMaker
In this Deep Learning Project, you will train a Text Generator Model on Amazon Reviews Dataset using LSTM Algorithm in PyTorch and deploy it on Amazon SageMaker.

Model Deployment on GCP using Streamlit for Resume Parsing
Perform model deployment on GCP for resume parsing model using Streamlit App.

Ecommerce product reviews - Pairwise ranking and sentiment analysis
This project analyzes a dataset containing ecommerce product reviews. The goal is to use machine learning models to perform sentiment analysis on product reviews and rank them based on relevance. Reviews play a key role in product recommendation systems.