Joining a Table

Join a table to existing vector data using a common field or column to match on using the Join tool.

To join a table, press the Join Attributes button in the Attribute Editor, or from the layer menu choose Join Attribute Table/File to Layer. This tool also available by right-clicking on the layer in the Control Center and going to the Layer submenu, then select JOIN- Join Attribute Table/File to Layer

The data in this example table join comes from the World Bank.
https://data.worldbank.org/data-catalog/ed-stats

Join File

File Name

Layer Attribute

Options

Duplicate Handling

When duplicate records are found there is a prompt providing options for handling the duplicate values:

Use case-sensitive comparisons — specifies whether or not text comparisons are case sensitive or not. Check this option to enable. By default comparisons are not case sensitive.

Ignore whitespace when looking for matches— specifies whether or not whitespace (i.e. spaces and tabs) should be ignored when looking for matches to join on. Check this option to ignore whitespace. By default whitespace is considered.

Join File Preview

The preview at the bottom of the dialog shows an example of the external table that will be added to the vector features.