Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
extract_lookup_table_attributes [2011/07/31 15:26] hermann created |
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). | | + | | 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). | | + | | 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 20-26). | | + | | 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 corresponding value in the original 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 | | ||