This functor extracts attributes and summary statistics from a lookup table.
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 |
Name | Type | Description |
Attributes | Lookup Table | Table containing the attributes extracted from a table. |
Key | Predefined Name | Description |
1 | “uniqueKeys” | number of unique keys (lines) |
The corresponding value in the original 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 |
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 |
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.
ExtractLookupTableAttributes