This is an old revision of the document!
PHP's gd library is missing or unable to create PNG images
Extract Lookup Table Attributes
Description
This functor extracts attributes and summary statistics from a lookup table.
Inputs
Name | Type | Description |
---|---|---|
Table | Lookup Table | A lookup table. |
Optional Inputs
Name | Type | Description | Default Value |
---|---|---|---|
Extract Statistical Key Attributes | Bool | If true, the calculation includes statistical key attributes (items 10-16). | True |
Extract Statistical Value Attributes | Bool | If true, the calculation includes statistical value attributes (items 20-26). | False |
Extract Dynamic Key Value Attributes | Bool | If true, the calculation includes statistical value attributes (items 30-32). | False |
Outputs
Name | Type | Description |
---|---|---|
Attributes | Lookup Table | Table containing the attributes extracted from a table. |
Group
Notes
The functor employs a lookup table with keys to the attributes. Each key has a predefined name. This name can be used to retrieve the corresponding attribute in Calculate Map, Calculate Categorical Map, Calculate Value and Calculate Lookup Table
Basic Attributes
Key | Predefined Name | Description |
---|---|---|
1 | “uniqueKeys” | number of unique keys (lines) |
Statistical Key Attributes
The value mapped to the key by each key/value pair is used as the number of key occurrences.
Key | Predefined Name | Description |
---|---|---|
10 | “minKey” | minimum key |
11 | “maxKey” | maximum key |
12 | “meanKey” | mean key |
13 | “modeKey” | mode key |
14 | “keyVar” | key variance |
15 | “keyStd” | key standard deviation |
16 | “medianKey” | median key |
Statistical Value Attributes
Key | Predefined Name | Description |
---|---|---|
20 | “minValue” | minimum value |
21 | “maxValue” | maximum value |
22 | “meanValue” | mean value |
23 | “modeValue” | mode value |
24 | “valueVar” | value variance |
25 | “valueStd” | value standard deviation |
26 | “medianValue” | median value |
26 | “medianValue” | median value |
Dynamic Key & Value Attributes
Key | Predefined Name | Description |
---|---|---|
30 | “keySum” | key sum (values are ignored) |
31 | “valueSum” | value sum |
32 | “keyValueProdSum” | sum of key/value product |
If it is not possible to determine any of those attributes, the corresponding entry in the lookup table is left blank.
Internal Name
ExtractLookupTableAttributes