Data Joins
The Join Data feature enables you to create a new dataset by joining multiple data sources from multiple connection types. The existing datasets must have at least one column in common in order to be joined.
Join Types
The following join types are supported:
- Left Join - Uses rows of data from the left table and the matching rows from the right table.
- Full Join - Uses all records in all joined tables.
- Inner Join - Uses only the rows of data that are common in the joined data. Rows that have no commonality between datasets are excluded.
- Right Join - Same as the left join, it uses rows of data from the right table and the matching rows from the left table.
To Create a Joined Dataset
- On the Design page, click the three-dot menu on the data source pill, and select Join to Another Data Source. For more information on using the Design page, see Overview of the Design Page.
On the Select the Data Source dialog, select the data source that you wish to join. Click the Connection, My Data, or Shared Data tabs to display existing data sources.
Click Next. The Join Data dialog displays.
Under Join Type, select the join type that you would like to use.
Click the dropdown box for each dataset and select the common columns. You can select more than one column for each link.
Click Save. The Join Output pill displays on the Design page.
Click Join Output to display all the combined columns from the joined datasets. This is the view of the output columns that will be loaded to the dataset. Click on any data source pill to filter the view to show only columns from the selected data source.
Repeat the join process as needed to achieve the desired structure for your dataset.
Click Apply Changes to make the joined datasets available to create charts, pages, and reports.
To Filter the List of Columns
A joined dataset may include a large number of columns that can be difficult to navigate. To filter the list of columns, click a data source pill. The list updates to display only the columns in that data source.
To Delete a Joined Dataset
To delete a joined dataset, click its three-dot menu and select Delete.