Join Data Objects in a Logical View

Creating joins between two objects is crucial for providing a comprehensive view of the data when information is distributed across multiple tables or datasets. You can define the type of join you want to create between two data objects in the logical view including left, right,and inner join.

Required Editions

Available in: All Editions supported by Data 360. See Data 360 edition availability.

User Permissions Needed
To create a join:	Semantic Models object permission OR Permission set: Data Cloud Architect

Often, data is stored in separate tables to maintain efficiency and organization. For example, sales transactions may be in one table, while customer details are in another. A join lets you combine these tables to view sales alongside customer information, allowing a more comprehensive analysis.

Important You must create joins between all data objects in the logical view, otherwise you can’t preview or save the logical view.

1. In Data Cloud, on the Semantic Layer tab, select a data model.
2. On the Model tab, expand Logical Views.
3. Create or edit a logical view.
4. To add a join, click the plus sign next to the object and from the dropdown select Join Object.

   

5. From the dropdown menu, select Join.
6. Select the object that you want to join and then click Save.
   You can only join one object at a time. After you select the data object you need to select the join type and select which data object fields you want to join together.

   

7. Select the join type.
   The join type determines which rows and fields are available.
   • Left Join—Returns all records from the left table and the matched records from the right DMO.
   • Inner Join—Returns all records that have matching values in two DMOs.
   • Right Join—Returns all records from the right table and the matched records from the left DMO.
   • Outer Join—Returns all records when there’s a match in either the left or right DMO.
8. Under Select Matching Data Object Fields, click the plus sign and select the matching data objects for the logical view.
   1. Under the left object, search for the field name.
   2. Under the right object, search for the matching field name.
   3. Click Add.

      

   4. Repeat this process for each pair of matching fields that you want to add. After you add your fields the bottom pane shows a preview of the logical view.
   5. Click Apply.

      A line connecting the two objects indicates that the join is successful.

      

9. Continue adding objects and creating joins to build your full logical view.
10. After you’re done click Preview Logical View.

    

    If the preview doesn’t work, check the logical view for errors and that the joins are correct.
11. To limit the preview to specific columns, go to the Columns tab and select the columns to include.