Combining data from multiple tables

When multiple source tables are available, you can combine their data:

  1. In the left-hand panel, click Datasets and select the dataset you need. If you do not have a dataset, create one.

  2. In the top-left corner, select the Sources tab.

  3. Under Tables, select a table and drag it to your workspace.

  4. Select another table and drag it to your workspace. A link will automatically be created between these tables based on the first matching field name and field data type.

    Note

    When you merge data from multiple tables, a dataset will get duplicates of the fields used to create links. You can remove them manually from the list of dataset fields. You can also describe the dataset using an SQL query and exclude duplicate fields from the final set.

  5. To edit this table link:

    1. Click the table link icon.

      image

    2. Select the join type: inner, left, right, or full.

    3. Select the fields to join the tables on. You can only link fields with the same data type.

    4. If required, link other fields in the tables. To do this, click Add link.

    5. Optionally, you can disable the Optimize link option to make the link required. In this case, the JOIN operation will run even if you select fields from only one table.

    6. Click Apply.

  6. Repeat steps 4 and 5 to add tables.

  7. When the third and subsequent tables are added, link are automatically created to the first table in the workspace.

    image

    A link will automatically be created between these tables based on the first matching field name and field data type.

    image

    When dragging a new table to the workspace, you can explicitly specify which table to link it to. Hover the new table over a previously added one to have a gray border display around the latter and release.

    image

    A new link to the specified table is created.

    image

    You can replace a previously added table. When dragging a new table, hover it over the icon with circular arrows to the right of the table you are replacing for the icon background to turn blue, then release.

    image

  8. Click Save.

You can add data to a dataset using an SQL query and combine this data with other tables.

See also