---
schema_version: "1"
id: 4d2ea9ca7f29e4239a03f3be7001b9de39659de120a65254302a51b7f37080de
title: Create a Union
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/c360_a_sl_unions_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.c360_a_sl_unions_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b52a2f8ddf7c6e05b1980486830cbade9ed7293369039557d38ff2ec2ab7e593
description: Merge datasets that share similar structures in a logical view. You can create one union per logical view. You cannot combine unions and joins.
products:
  - Data 360
release: "264"
---
# Create a Union

Merge datasets that share similar structures in a logical view. You can create one union per logical view. You cannot combine unions and joins.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: All editions supported by <span>Data 360</span>. See <a href="https://help.salesforce.com/s/articleView?id=data.c360_a_dc_editions.htm&amp;language=en_US" target="_blank"><span>Data 360</span> edition availability</a>.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:left;vertical-align:top;" id="d18603e63">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d18603e63 ">To create a union:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d18603e63 ">
              <p>Permission set: </p>
              <ul>
                <li>Data Cloud Architect</li>

              </ul>
              <p>AND</p>
              <p style="margin-bottom:0;">Semantic Models object</p>
            </td>

          </tr>
        </tbody>
      </table>

1. In Data Cloud, on the Semantic Layer tab, select a data model.
2. Create or edit a logical view.
3. Select the data object you want to create a union for, and then click the plus sign.
4. From the dropdown menu, select **Create Union**.
    
    ![Add union to LV](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-semantics-264-0-0-production-enus/f7c99ab1-3439-4722-b925-34cb47455d89/semantics/images/semanticlayer/SL_Logical_View_Add_Union.png)
5. In the **Select Data Object for Union** window, select the objects you want to unite. You can select up to nine objects.
    
    ![Add union to LV](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-semantics-264-0-0-production-enus/f7c99ab1-3439-4722-b925-34cb47455d89/semantics/images/semanticlayer/SL_Logical_View_Union_Add.png)
    
    The merged fields in the union receive metadata from the first added object.
6. Select the fields (table columns) that you want to include in the union.
7. Click **Save**.
    
    A preview of the selected object and fields appears.
    
    ![Union preview](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-semantics-264-0-0-production-enus/f7c99ab1-3439-4722-b925-34cb47455d89/semantics/images/semanticlayer/SL_Logical_View_Union_Preview.png)
8. Select matching fields. These are fields that represent the same information and can be merged into one. Click **Add** when done, You must match at least two fields.
9. Search for matching fields and click **Add** when done. You must match at least two fields.
    
    ![Matching fields](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-semantics-264-0-0-production-enus/f7c99ab1-3439-4722-b925-34cb47455d89/semantics/images/semanticlayer/SL_Logical_View_Matching.png)
10. When all sets have been added, click **Apply** to add the new union to the logical view. The union appears in the Semantic Model Builder Canvas.
    
    ![LV with union in canvas](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-semantics-264-0-0-production-enus/f7c99ab1-3439-4722-b925-34cb47455d89/semantics/images/semanticlayer/SL_Logical_View_Done.png)