> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Join Forces

One of the most useful tools in your toolbox is to merge dataset. To that end, we have a couple of quite neat tools: [Combine](/tools/merge/combine), [Stack](/tools/merge/stack) and [Append](/tools/merge/append).

The Combine tool - which is perhaps the most valuable tool out there - merges two datasets by one or multiple IDs - it's like a SQL join or a XLOOKUP/VLOOKUP in Excel. The Stack tool stacks datasets on top of each other. The Append tool attaches a number of rows and columns to a different dataset.

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/p3fagpmjc7to3OA6B1OeBd5UPRKS01CfxvSPCIgcFipU?metadata-video-title=Tools+-+Join+Forces&video-title=Tools+-+Join+Forces&autoplay=1&muted=1&accent-color=%232b8761" allow="accelerometer; gyroscope; autoplay; encrypted-media; picture-in-picture;" allowfullscreen="true" />
</Frame>

## Exercise

We're working with the *NATION* and *REGION* datasets and you want to get the result shown below. We end up with eleven rows and used nine tools to get the result.

<Frame>
  <img src="https://mintcdn.com/less-51/7vxLoN8O_CeWSGG4/images/academy/beginner/4result.png?fit=max&auto=format&n=7vxLoN8O_CeWSGG4&q=85&s=3eb498b7ea7617a835de68c308a5c518" width="3432" height="692" data-path="images/academy/beginner/4result.png" />
</Frame>

Note that we use all three tools (Combine, Append and Stack) to get the result. And you should too.

1. We start by combining the *NATION* and *REGION* datasets.
2. We use a [Manual Input](/tools/utilities/manual-input) tool to create a new small dataset. It contains two rows in a column called *filter* (EUROPE and AMERICA). We attach this and use a Filter to ensure that all our rows are either in Europe or America.
3. We use a second Manual Input tool to create a new small dataset. It contains one rows with two columns *country* (value = DENMARK) and *region* (value = EUROPE). We put this dataset on top of the original combined NATION+REGION dataset.

## Solution

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/9vCMLFL02dd2RDXHGIDyGRliLb015RWS1Z7aOI8FEkN01Y?metadata-video-title=Solution+-+Join+Forces&video-title=Solution+-+Join+Forces&accent-color=%232b8761&&poster=https://less-docs.s3.eu-central-1.amazonaws.com/SolutionJoinForces.png" allow="accelerometer; gyroscope; encrypted-media; picture-in-picture;" allowfullscreen="true" />
</Frame>
