Joining a Table
Join a table to existing vector data using a common field or column to match on using the Join tool. From the layer menu choose Join Attribute Table/File to Layer. This is 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
Join File
File Name
- File Name — Choose the table to join. Supported formats include csv, txt, dbf and other simple ascii text files.
- Join File Delimiter — Specify the delimiter used in the file to separate values. If the join file is a DBF, this field is not applicable, and will be disabled.
- Join File Attribute — Select the name of the attribute that matches an attribute in the existing layer. This is sometimes referred to as the Foreign Key or Common Attribute. The attribute names come from the first row of the table.
Layer Attribute
Options
Duplicate Handling
When duplicate records are found there is a prompt providing options for handling the duplicate values:
- Abort the join — cancel the join operation
- Keep Attributes From Last Record Matching Join Attribute— keep the attribute values from the last matching record in the join file
- Keep Attributes From First Record Matching Join Attribute — keep the attribute values from the first matching record in the join file
- Keep All Matching Records, Append Values to End of Attribute — keep all matching records from the join file, appending new values to the existing attribute with a comma separator. For example if the table had one matching record with a value of Mike and another matching record with a value of Sam, the resulting joined table would have a value of "Mike, Sam".
- Keep All Matching Records, Append Values to End of Attribute, Sorted — keep all matching records from the join file, appending new values to the existing attribute with a comma separator. See below for the sort order.
- Sort duplicates in ascending order — this will be enabled when the sorted option is chosen from the list. When checked, the list of duplicate attributes values will be sorted in ascending order. If it is not checked, the sort will be in descending order.
- Keep All Matching Records in New Attribute Names — keep all matching records from the join file, but create new attribute values with a numeric suffix for the multiple entries. For example if there were 5 matching records with an ADDR attribute, you would get ADDR, ADDR2, ADDR3, ADDR4, and ADDR5 attributes added
- Duplicate Feature for Each Duplicate Join Attribute — create duplicate features for each record with a duplicate join attribute, one addition feature for each duplicate join attribute value.
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.