Join Data in Query

You can combine data from multiple Datamarts. Two types of joins are available:

• Inner Join

• Left Outer Join

Following the steps from How to Create a Query. Here are the steps to join data in a query.

1. In the Join Data section:

2. Click on the icon.

3. Select the join type

4. Select the Data Source for joining from Join with drop-down menu.

5. Select Column or multiple Columns in the Select Column(s) drop-down menu.

6. Select the Joining Key.

   

7. Click Save.

   

8. In the Save Query menu:

   1. Enter a Label.
      Title used for display and translations.

   2. Enter a Name.
      Mandatory and unique identifier. Changing it can break dependencies. Prefer using the Label for naming visible to users.

   3. In the Save to Folder section, select the folder where the query will be saved.

   4. Click Save.

When you return to the Query List screen, the query will be saved in the selected folder.

Example

In our example we are joining the following two Datamarts:

• Testing Actin Data

• Meatball Transaction DM

Field Selection

• Testing Actin Data

  • Customer Id

  • Customer Class

  • Product Id

  • Quantity

• Meatball Transaction DM

  • Country

  • Product Label