Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
extract_lookup_table_attributes [2013/03/15 23:50] admin [Statistical Key Attributes] |
extract_lookup_table_attributes [2016/07/21 17:32] (current) hermann [Statistical Key Attributes] |
||
---|---|---|---|
Line 7: | Line 7: | ||
===== Inputs ===== | ===== Inputs ===== | ||
- | ^ Name ^ Type ^ Description ^ | + | ^ Name ^ Type ^ Description ^ |
- | | Table | [[ Lookup Table Type| Lookup Table ]] | A lookup table. | | + | | Table | [[Lookup Table Type]] | A lookup table. | |
===== Optional Inputs ===== | ===== Optional Inputs ===== | ||
- | ^ Name ^ Type ^ Description ^ Default Value ^ | + | ^ Name ^ Type ^ Description ^ Default Value ^ |
- | | Extract Statistical Key Attributes | [[Bool Type|Bool ]] | If true, the calculation includes statistical key attributes (items 10-16). | True | | + | | Extract Statistical Key Attributes | [[Boolean Value Type]] | If true, the calculation includes statistical key attributes (items 10-16). | True | |
- | | Extract Statistical Value Attributes | [[Bool Type|Bool ]] | If true, the calculation includes statistical value attributes (items 20-26). | False | | + | | Extract Statistical Value Attributes | [[Boolean Value Type]] | If true, the calculation includes statistical value attributes (items 20-26). | False | |
- | | Extract Dynamic Key Value Attributes | [[Bool Type|Bool ]] | If true, the calculation includes statistical value attributes (items 30-32). | False | | + | | Extract Dynamic Key Value Attributes | [[Boolean Value Type]] | If true, the calculation includes statistical value attributes (items 30-32). | False | |
===== Outputs ===== | ===== Outputs ===== | ||
- | ^ Name ^ Type ^ Description ^ | + | ^ Name ^ Type ^ Description ^ |
- | | Attributes | [[ Lookup Table Type| Lookup Table ]] | Table containing the attributes extracted from a table. | | + | | Attributes | [[Lookup Table Type]] | Table containing the attributes extracted from a table. | |
===== Group ===== | ===== Group ===== | ||
Line 37: | Line 37: | ||
==== Statistical Key Attributes ==== | ==== Statistical Key Attributes ==== | ||
- | The value mapped to the key by each key/value pair is used as the number of key occurrences. | + | <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 ^ | ^ Key ^ Predefined Name ^ Description ^ | ||
Line 57: | Line 60: | ||
| 24 | "valueVar" | value variance | | | 24 | "valueVar" | value variance | | ||
| 25 | "valueStd" | value standard deviation | | | 25 | "valueStd" | value standard deviation | | ||
- | | 26 | "medianValue" | median value | | ||
| 26 | "medianValue" | median value | | | 26 | "medianValue" | median value | | ||