Combining data from multiple tables

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

1. Open the dataset. If you don't have a dataset, create one.

2. In the upper left-hand 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.

      

   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.

   

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

   

   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.

   

   A new link to the specified table is created.

   

   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.

   

8. Click Save.

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

See also

• Adding tables