Problems during Initializing a Subindex for a Joined Layer

Consider this chapter if problems arise during the creation of subindices or thematic full-text searches on layers with joins. The chapters shows how to check the join and identify duplicate field values with ArcMap.

Regarding the full-text search in WebOffice, joins may only consist of a 1:1 relation. If the data represents a 1:N or N:N relation, it must be configured in WebOffice as RELATE. Otherwise there might arise problems during the initialization of subindices of the respective layers. In other words, every related attribute value is assigned exactly to one other attribute value.

Note: See chapter Full-Text Search Tab for description of display in SynAdmin.

Join Validation in ArcMap

ArcMap allows a join validation. This validation can be achieved directly after creating the join in the properties of the respective layer. Validate the join after selecting source and target attribute fields and the table to be joined by clicking Validate Joiner. This will check field names for invalid characters, reserved words and consistency of data.

 Note: A join validation should always be executed during creation of the join to suspend any reasons that could lead to problems in WebOffice 10.8 SP2.

As a result you will get a connection validation with additional notes to potential problems. If a join contains a multiple relation that is not allowed for a join, it will be shown as Cardinality Warning. If this is the case, the dataset should either be configured as a relate or the duplicate entries should be checked. See the next abstract for details about the identification of duplicate entries.

Identification of Duplicate Object Field Values

If the table contains a lot of attribute entries, it is possible to use the function Summarize in ArcMap to show duplicate object field values and solve them. For identification, open the attribute table of the respective layer. Then execute field statistics for the attribute field that is used for the join. Right-click on the field and press Summarize, you will then see the following dialog.

By executing the function Summarize, single attribute values will be summarized and a feature count attribute field will be added. The exported table can be joined to the original table. The new attribute table may be sorted by the feature count attribute field. All field values in the column Count_<attribute field> other than 1 are duplicates that are not allowed with a join.