====== Extract Lookup Table Attributes ====== 

===== Description =====

This functor extracts attributes and summary statistics from a lookup table.

===== Inputs =====

^ Name  ^ Type  ^ Description  ^
| Table  | [[Lookup Table Type]]  |  A lookup table.  |

===== Optional Inputs =====

^ Name  ^ Type  ^ Description  ^ Default Value  ^
| Extract Statistical Key Attributes  | [[Boolean Value Type]]  | If true, the calculation includes statistical key attributes (items 10-16). | True  |
| Extract Statistical Value Attributes  | [[Boolean Value Type]]  | If true, the calculation includes statistical value attributes (items 20-26). | False  |
| Extract Dynamic Key Value Attributes  | [[Boolean Value Type]]  | If true, the calculation includes statistical value attributes (items 30-32). | False  |

===== Outputs =====

^ Name  ^ Type  ^ Description  ^
|  Attributes  | [[Lookup Table Type]]  | Table containing the attributes extracted from a table.  |

===== Group =====

[[Functor List#Table | Table]]

===== 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 ====

<note important>
The value mapped to the key by each key/value pair is used as the number of key occurrences for the calculation of the //Statistical Key Attributes//. Keys associated with negative or zero values are supposed not be presented in the table when the key attributes are being calculated and the corresponding keys are ignored.
If you do not want the value associated with the key to the used as the number of key occurrences, use a [[Calculate Lookup Table]] to turn the associated values into ones and run the attribute calculation on the resulting table -- the expression ''1'' can be used for that purpose.
</note>

^ 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             |

==== 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