Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
extract_lookup_table_attributes [2013/03/15 23:50] 127.0.0.1 external edit |
extract_lookup_table_attributes [2016/07/21 17:29] 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 to turn all values into zeros before performing the attribute calculation. | ||
| + | </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 | | ||