# 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FcNQgXVaGMvn2QiSvd62e%2FMergeDatastore_Story.gif?alt=media\&token=724cc2e7-c993-4c67-9c68-ee12e6b9c8a6)

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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F9EMEt6KyLRLjo89Pyhff%2Fimage.png?alt=media\&token=5272f32f-519e-42c8-a4c6-a00302ec9031)

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

    ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FyLJ2waQdYArVsQI3PkKi%2Fimage.png?alt=media\&token=b4958bf0-c016-4d1a-b4a7-20b485006772)

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

      ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F6GSI21XFOOlZporpV8tf%2Fimage.png?alt=media\&token=673d37d5-689e-4639-96ed-9f0894ae83bc)

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

    ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FEChRdyGt6v4OQOf0rq1R%2Fimage.png?alt=media\&token=66c0d3e7-70cf-4e4e-8ae4-14de52bc3caf)

* 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. 

      ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FW2KojVJEofNuO1Yl0av7%2Fimage.png?alt=media\&token=eb12250e-abbb-4426-9aca-75eb1939a65d)  

* 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FCFHsr1JqnTqAtIySdz3W%2Fimage.png?alt=media\&token=454a7e5d-caac-42f6-a1c6-38af93cde344)

* 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FQ0BbSuboE03kHNqJHtH0%2Fimage.png?alt=media\&token=059bc7c8-6ee6-4d20-89e1-87929f4bed32)

* 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FKyYnjJAXznOR3aUjvBmF%2Fimage.png?alt=media\&token=18dc6e37-5fd6-43b9-aa2b-0d675178a414)

{% 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;      ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Frp1MUh40Nytg5Lv5Mj7W%2Fimage.png?alt=media\&token=949845a9-3203-497e-96de-8a4447737f7e)

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