Template:Filter Dataset Values
From XMS Wiki
Revision as of 15:22, 6 August 2021 by Jcreer (talk | contribs) (Created page with "__NOINDEX__ ===Filter Dataset Values=== This tool allows creating a new dataset based on specified filtering criteria. The tool has the following options: ; Filter : This cre...")
Filter Dataset Values
This tool allows creating a new dataset based on specified filtering criteria. The tool has the following options:
- Filter
- This creates a new dataset based on specified criteria. The following options are available for filtering:
- < (less than)
- <= (less than or equal to)
- > (greater than)
- >= (greater than or equal to)
- equal
- not equal
- null
- not null
- If the value passes the specified filter, the following can be assigned:
- original (no change)
- specify (a user specified value)
- null (the dataset null value)
- true (1.0)
- false (0.0)
- time – The first time the condition was met. Time can be specified in seconds, minutes, hours or days, and includes fractional values (such as 3.27 hours).
- In addition, if the value passes none of the criteria, a default value can be assigned (see available options above).
- The filtering is applied in the order specified. This means as soon as the new dataset passes a test, it will not be filtered by subsequent tests.
