Split Attributes¶
Use this dialog to split an attribute based on its values, so you get multiple attributes that can be used in an XREF table. Both the attribute and its values are split, and you can do this for many attributes.
Preview¶
You can test whether the split produces the expected result by using the preview. Enter an attribute value manually, and you will see the new attributes and their values in the result field.
When the split is defined and you close the dialog, the new attributes become available for cross-referencing, just like other attributes in the application layer. Often, you want the new attributes to be linked to corresponding attributes in the result application layer. You can easily do this by checking Insert automatically in XREF table in the dialog when defining a new attribute.
Examples of Splitting¶
Unformatted splitting
The starting point is an attribute where the value contains information about several properties of the object:
- Attribute: Layer
- Attribute value (example): 42111-SP-1200
Using the field separator "-", the result is three new attributes, one for each property:
- Attribute1: 42111
- Attribute2: SP
- Attribute3: 1200
Formatted splitting
The starting point is an attribute where the value contains information about several properties of the object:
- Attribute: Layer
- Attribute value (example): VL200
With position 0 and length 2 for the first attribute, and position 2 and length 3 for the second attribute, the result is:
- Attribute1: VL
- Attribute2: 200
Procedure¶
Procedure
- Open the XREF table for editing.
- Click the Split attributes... button.
- Select the source attribute and click Add....
- Check which geometry types the split should apply to (lines, polygons, etc.).
- Set up the split options.
- Click Add... in the result attributes list and enter the field name/attribute name.
- Repeat for the remaining attributes.
- Optionally, test the split by entering a relevant value in the preview.
- Click OK in the dialog to return to the XREF table.