Consolidate Attributes
Description
Consolidate AttributesThe Consolidate Attributes tool allows consolidating the source attribute in the source layer based on a relationship (Link Field) between the source layer/table and the target layer/table. Only layers having relationships may be selected as target or source layer. The source has to be different from the target, and related to it. How the function worksFor each target feature, the function finds the related source features based on a predefined relationship, and performs the selected consolidation operation on these source features. The result of the consolidation is stored in the target field. Options for consolidation operations include Sum, Max, Min, Count, Average, Median, Mode, and Standard Deviation.
Usage
Parameters
| Parameter Name | Type | Direction | Data Type | Dialog Reference |
|---|---|---|---|---|
| Target Table | Required | Input | Table View | Table that the selected attributes from the source table will be consolidated to. |
| Target Link Field | Required | Input | Field | Field that links to source table (target_table.target_link_field=source_table.source_link_field) |
| Source Table | Required | Input | Table View | Source table whose selected source fields will be consolidated to the target table's target_fields |
| Source Link Field | Required | Input | Field | Field that links to target table (target_table.target_link_field=source_table.source_link_field) |
| Consolidate Parameters | Required | Input | Value Table | Consolidate_Parameter (with 4 elements: Target_Field, Source_Field, Statistics_Op, Weight_Field), MultiValue=True vt_params = arcpy.ValueTable(4)Target_Field = Statistics_Op(Source_Field) |
| Load From Configure File | Optional | Input | Text File | File with Pre-configured values for the Consolidate_parameters, Format: ";" delimited parameter items, a parameter item is a space " " delimited entries of Target_Field, Source_Field, Stat_Op, Weighted_Field. Example of file contents: TSUM Q Sum #;TAvg Q Average #;TMax Q Maximum #;TMin Q Minimun #;TAvgWeighted Q 'Weight Average by Field' Q |
| Output Configuration File | Optional | Output | Text File | File Path to save the Consolidate Parameters of this computation for later use. |