# Data Store Merge at View Level

{% hint style="info" %}
Check out the given walk-through on how to create a Data Store Merge at the view level.
{% endhint %}

![Data Store Merge at the View level](/files/XKCr7lQllXxJFA1KSepb)

The users can merge multiple data stores at the view level to compare different measure values across the merged datastores.

* Navigate to the Design New page.
* Drag and drop dimension(s) and measure(s) from the selected Data Store onto the canvas to create a view.
* Click the ***ALL DATA STORE*** option.             

![Creating a View by using the Design page with the first Data Store](/files/cOYKCtG7d7iAOdar6owk)

* The ***Data Store*** dialog box opens.
* Search for a Data Store using the search bar.
* Click the ***Merge*** icon for the selected Data Store.

    ![](/files/VNI2LD6anoYOtW55sw1c)

* The user gets redirected to select a related field from the drop-down menu.
* Click on the ***MERGE*** option.

      ![](/files/PjXngYfvQMaadRmtG1Yf)

* A success message appears to confirm the merge of the selected ***Data Stores**.*

    ![](/files/9iqOG1hxuuiAQPd4BVif)

* The selected ***Data Store*** gets added to the ***Data Store*** space, and a drop-down icon appears to choose any one ***Data Store*** out of the given choices. 

      ![](/files/M1ks8jJ9B7nuqcZBL6bw)  

* Drag and drop a measure from the newly added Data Store to create a comparative view.     

![Creating a comparative view by dragging a measure from another Data Store](/files/aXQExdmbJ1ugyOwHvCgE)

* The user can add multiple ***Data Stores*** by using the same set of steps.
* Drag the required measures to add the corresponding fields in the view.
* Click the ***Save*** icon.  

![Saving the comparative View with based on Multiple Data Store](/files/fFxEfV1CQFQx0RrDefAu)

* A success message appears, and the view gets added to the storyboard.
* Click the ***Save*** icon from the storyboard to save the entire ***Story***.    

![Saving the comparative view on the Storyboard](/files/qdkcY7p1wCY4YgKWOS8F)

{% hint style="warning" %}
*<mark style="color:green;">Please Note:</mark>*

* *All the merged data stores can be accessed for the saved view by using the ‘**Edit**’ option from the storyboard.*

  * *The user can modify the view by selecting the **Edit** option from the storyboard.*

  &#x20;      ![](/files/pcwDLJsAQN5nQkl7msLx)

  * All the merged Data Stores can be accessed for that view even in the ‘**Edit**’ mode.
  * The user can change the title of a Saved View title by opening the Design New page of the view via the ‘**Edit**’ option.
* The Merged Data Stores do not get saved in the ‘**ALL DATA STORE**’ menu, so to add the subsequent new view based on merged data stores into the same business story, the users need to merge the data stores yet again.
  {% endhint %}


---

# 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.bdb.ai/bdb-documentation/data-visualization/self-service/design/data-store-merge-at-view-level.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.