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