Extracts general attributes and basic statistics from a lookup table, returning them as a lookup table keyed by a predefined attribute code.
| Name | Type | Description |
|---|---|---|
| Table | Lookup Table Type | Lookup table whose attributes will be extracted. |
| Name | Type | Description | Default Value |
|---|---|---|---|
| Extract Statistical Key Attributes | Boolean Value Type | If true, statistical key attributes (items 10-16) are also extracted. | True |
| Extract Statistical Value Attributes | Boolean Value Type | If true, statistical value attributes (items 20-26) are also extracted. | True |
| Extract Dynamic Key Value Attributes | Boolean Value Type | If true, dynamic key and value attributes (items 30-32) are also extracted. | True |
| Name | Type | Description |
|---|---|---|
| Attributes | Lookup Table Type | Table of extracted attributes, keyed by attribute code. |
Each attribute has a predefined name that can be used to retrieve it by name (rather than by numeric key) with the tX[“NAME”] syntax in Calculate Map, Calculate Categorical Map, Calculate Value, and the lookup table calculators.
If an attribute cannot be determined, its entry is omitted from Attributes rather than being filled with a placeholder.
Static attributes and their keys: 1 “uniqueKeys” (number of unique keys, i.e. rows).
Statistical key attributes and their keys (present only when Extract Statistical Key Attributes is true), where each key's associated value is used as that key's number of occurrences: 10 “minKey”, 11 “maxKey”, 12 “meanKey”, 13 “modeKey”, 14 “keyVar”, 15 “keyStd”, 16 “medianKey”. Keys associated with a negative or zero value are treated as absent from the table for this calculation. To instead treat every key as occurring exactly once regardless of its associated value, first pass Table through a Calculate Lookup Table Values with the expression 1 to turn every value into 1, and extract attributes from the result.
Statistical value attributes and their keys (present only when Extract Statistical Value Attributes is true): 20 “minValue”, 21 “maxValue”, 22 “meanValue”, 23 “modeValue”, 24 “valueVar”, 25 “valueStd”, 26 “medianValue”.
Dynamic key and value attributes and their keys (present only when Extract Dynamic Key Value Attributes is true): 30 “keySum” (sum of the keys; associated values are ignored), 31 “valueSum” (sum of the values), 32 “keyValueProdSum” (sum of each key multiplied by its associated value).
The minimum and maximum key or value attributes are only determined when Table has at least one entry.
ExtractLookupTableAttributes