# Merge

Merge multiple data frames by row.

## How to Access This Feature

### From + (plus) Button

![](/files/-M4oNAD7hJYw9kqHAmIK)

* Click "+" button and select "Merge (Add Rows / Union)"

## Bind multiple data frames by row

![](/files/zhBbchNCkSyVzxUmgcgx)

1. Select Operation Type for the Merge. Supported options are:

* Bind Rows (Merge all rows)
* Union (Merge only unique rows)
* Intersection (Merge only the common)
* Setdiff (Merge only the difference)

1. Select the Data Frames you want to merge. You can select a single or multiple data frames.
2. (Optional) You can enable 'Reserve Data Frame Name' option to create a new column to hold the names of merged data frames.
3. (Optional) You can enable 'Force Data Type to Match' to merge the data frames even when the data types of the corresponding columns are different. After the merge, it detects and assigns appropriate data types automatically.


---

# Agent Instructions: 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:

```
GET https://docs.exploratory.io/data-wrangling/merge.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.
