> For the complete documentation index, see [llms.txt](https://docs.akkio.com/akkio-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.akkio.com/akkio-docs/prepare-your-data/prepare/merge.md).

# Merge & Fuzzy Merge

Beyond connecting a single dataset, you can create a new dataset by merging two or more datasets. Akkio supports both Exact Match and Fuzzy Match merging. Your data sources do not need to be in the same format or system; for example, you can have one from a CSV and another from Salesforce.

<figure><img src="/files/5O5iSRMJsAAAvx32faNS" alt="" width="530"><figcaption></figcaption></figure>

We will now merge two sets of housing data with a fuzzy merge.  Select 'Merge' from the top left area of Prepare to open the guided process.

<figure><img src="/files/ILAu38VxtHDCfBc4X8S6" alt="" width="563"><figcaption></figcaption></figure>

You can now select the Secondary Dataset to merge and the column to match. Two housing datasets are merged on the Sale Price column in the example below.  You can select additional columns as well, such as Lot Area. Once the columns are selected, press 'Merge Datasets.'

<figure><img src="/files/APXrJ8B89QevUv8bJXHO" alt="" width="563"><figcaption></figcaption></figure>

### Advanced

For additional control, specifically of fuzzy merging, advanced options are available as part of the merge function.

<figure><img src="/files/XRZQlNdog2M78ZprZugd" alt=""><figcaption></figcaption></figure>

#### Match Sensitivity

By default, the matching sensitivity is “Exact Match Only,”  which will only merge the datasets on exact column matches.

Alternatively, you can select “Fuzzy Match,” meaning the datasets will be merged, even if the column names aren’t identical.

#### Merge Type

The next setting is “Merge Type,” which allows you to select between these two options:

* Keep all rows in the primary dataset.
* Keep only rows that appear in both datasets.

#### Merge Score

Scored 0-1, this value demonstrates how similar the records are, with 1 being a perfect match and 0 being completely different.

#### Append (Vertical) Merge

The current UI only supports horizontal merging. Appending rows/ merging vertically is not currently an option within the UI. However, this can be configured through the API.

#### Merge Pricing

Exact Merge is available to Basic and Professional level plans. While Fuzzy Merge is only available to Professional.

###


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.akkio.com/akkio-docs/prepare-your-data/prepare/merge.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.