> 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 Combining two datasets into one 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.
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.
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.'
### Advanced For additional control, specifically of fuzzy merging, advanced options are available as part of the merge function.
#### 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 by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.akkio.com/akkio-docs/prepare-your-data/prepare/merge.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. 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.