Define joins between data sources

To define a join, you select the common column for the data sources and then specify a join type. When creating a dataset with two or more data sources, the system automatically identifies the common columns and suggests joins between them. You can view and edit these joins when creating or editing a dataset.

Prerequisites
  • You are creating or editing a dataset.

  • You uploaded at least two data sources. For example, two or more tables from one or several database sources; an Excel file with at least two sheets; a file with at least one sheet and a table from a database source.

  • The Step 3 – Join and preview page is open.

Procedure

Depending on the view, the steps for managing joins are different.

List view is set by default. To switch between the views, use the buttons in the upper-right corner of the page.