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.

  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. 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 being replaced to turn the icon background 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