- Data model
- Data types
- Data type mapping
- Dataset settings
Combining data from multiple tables
When multiple source tables are available, you can combine their data:
In the left-hand panel, click create one.Datasets and select the dataset you need. If you do not have a dataset,
In the top-left corner, select the Sources tab.
Under Tables, select a table and drag it to your workspace.
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.
To edit this table link:
Click the table link icon.
Select the join type:
Select the fields to join the tables on. You can only link fields with the same data type.
If required, link other fields in the tables. To do this, click Add link.
Repeat steps 4 and 5 to add tables.
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.
You can add data to a dataset using an SQL query and combine this data with other tables.