> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/design/data-store-merge-at-view-level.md).

# 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 %}