Tech
Ai
Data
News
Learning

How to Combine Multiple Tables Horizontally in Alteryx

August 7, 2018
How to Combine Multiple Tables Horizontally in Alteryx
Speak to One of our Learning Consultants Today
Talk to Sales

Joining tables together is a common task in Alteryx. In this post, we’ll discuss how to combine tables horizontally using the Join tool. The Join tool is used to combine tables which are linked by a common field. It is slightly more complex than the Union tool that we saw in a previous post, but is not difficult to understand once you grasp the principle of how it works.

The Join tool

The Join tool is used to combine tables horizontally. It is used when you have two tables that contain different pieces of information but are linked by a common field. Using the join tool makes your data wider, adding more information to your existing records. Joining is used when you want to merge or blend two tables together to create a single wide table.

Join tool example

Let’s look at an example of joining in Alteryx. Below is a sales dataset which shows sales of corporate event packages. Note that one of the columns is called Customer Number. This column indicates the customer that this particular sale was made to.

Customer No Corporate Even Package

Separately, the business has a file containing information on the customers, which we can see below. Again, we have highlighted the Customer Number column. We’re going to use the Join tool to combine these two tables into one. We’ll use the Customer Number as the common field to merge the two tables.

Customer No Customer Information

The join tool is found on the join tab. When we bring it onto the canvas, we get the workflow shown below, where the join tool is highlighted. Note that our sales data is made up of three files which we combined previously using a Union tool.

Ateryx Union & Join

The join tool has exactly two inputs. One connects to the L input node and is considered the left input, the other connects to the R input node and is considered the right input.

Join Details

Before we run the workflow, we’ll want to configure the tool by specifying the fields used in the join. Below we see the configuration window for this particular join.

Alteryx Join details

As we saw earlier, the field common to both tables is Customer Number, so we specify that as the field to join by from both the left and right input tables. Now the two tables will be merged using the Customer Number field.

Join Output

Once the join tool is set up, we can run the workflow to execute the join. The join tool produces three different outputs, which we’ll discuss now.

Looking at the workflow above, we can see that the join tool has three output nodes: L, J and R, each of which contains a data set. Each of the data sets contains all the columns from both of the input tables. What varies between each node is which rows from the input tables are included. The configuration window above graphically illustrates what these three outputs contain.

  • The J output node contains data found in both input tables. This is also known as an inner join. In this example, the dataset at this node contains customer numbers that are found in both the sales table and the customer table.
  • The R output node contains data that is found only in the Right input table. In our example, this contains customers found in the customers table but not in the sales table. These would generally be previous customers who have not made a purchase during the length of the sales data.
  • The L output node contains data that is only found in the Left input table. In our example, this would be customers found in the sales table but not in the customer table. This could happen with very new customers who the company sold to recently, but who have not yet been recorded in the customer database.

Discussion

The Join tool can be a useful tool when merging tables horizontally in Alteryx. It takes exactly two inputs, and produces three outputs, that are actually quite easy to understand. You can join using one common field, as we saw here, or using multiple common fields, if you need to.

It can also be useful as a filtering tool. Focusing on the inner join output allows you to filter out any records which have incomplete data.

Most Recent

How to Create a Sources and Uses Table for a Leveraged Buyout Transaction
Tech
Ai
Data
News
Learning
The Good, the Bad and the Ugly of HR Analytics
Tech
Ai
Data
News
Learning
5 Ways You Can Maximize the Impact of Your Charts
Tech
Ai
Data
News
Learning

For nearly a decade, Kubicle has set new benchmarks in corporate training, empowering over one million learners across more than 1,000 enterprises worldwide. The mission has always been to foster valuable, measurable skills that drive organizational success.

However, teaching new skills alone isn’t enough to create lasting change. To bridge the gap between learning and real-world impact, businesses require more robust, integrated approaches. That’s why Academies+ has been developed—an innovative blended learning program designed to transform skill acquisition into tangible outcomes.

Why Blended Digital Learning?

eLearning alone is a proven tool for effectively upskilling large groups. Organizations leveraging Kubicle’s solutions often see significant performance improvements after just a few hours of tailored training. However, learning a new skill is only half the battle. The real challenge is ensuring those skills are applied effectively within an organization’s unique context to maximize its impact.

In recent times, an additional challenge has emerged: the rapid acceleration of change, especially in technology. The production timelines for eLearning courses often struggle to keep pace with product development, nowhere more obviously than in the domain of Generative AI. As a result, a course being developed today may already be outdated by its release—regardless of how short the production cycle is.


Blended learning tackles these challenges by merging the advantages of eLearning with hands-on, real-world applications. Likewise, virtual classrooms led by industry-leading SMEs offer an effective platform for delivering consistently up-to-date content. This approach enhances knowledge retention while ensuring accuracy and smooth integration into daily workflows.

How It Works: The Academies+ Formula:
Self-paced eLearning + Virtual Classrooms & Workshops + Impact Coaching + Impact Project = Maximized Organizational Impact

Our unique design of blended learning interventions are aligned to one thing, Impact.

Learners start by exploring foundational concepts at their own pace with self-guided eLearning. This flexible format allows them to absorb and reflect on the material before moving on to interactive virtual classrooms. Here, subject matter experts and peers provide fresh insights, helping to deepen understanding through discussion and collaboration.

The experience continues with hands-on workshops, where learners put their new skills to the test in a practical setting, guided by experts. But the real differentiator of Academies+ lies in its final components: the Impact Project and the Impact Coach.

The Impact Project is where learning meets real-world impact. Through the Impact Project, learners will address genuine business challenges and make a measurable difference. With the support of an Impact Coach, participants develop a project tailored to their organization’s needs, applying their newly acquired skills to solve genuine problems and deliver tangible results.

With Kubicle’s Academies+, we don’t just train—we transform, turning learning into a strategic asset for your organization.

Launching Now: AI for Business Professionals Academy+

In 2025, Kubicle will roll out a series of Academies+ programs addressing critical skill gaps in organizations. The first program, AI for Business Professionals Academy+, is now open for enrollment.

This program is designed to equip leaders and professionals with the skills to harness AI effectively in their roles. As regulations like the EU AI Act approach, organizations must meet AI literacy standards. This program prepares participants to not only understand AI principles but also apply them to improve productivity and efficiency.

By the end of the course, participants will view AI not as a buzzword but as a practical tool for solving business challenges and driving innovation.