Template:Filter Dataset Values: Difference between revisions
From XMS Wiki
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
__NOINDEX__ | __NOINDEX__ | ||
===Filter Dataset Values=== | ===Filter Dataset Values=== | ||
This tool allows creating a new dataset based on specified filtering criteria. The tool has the following options: | This tool allows creating a new dataset based on specified filtering criteria. 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. The tool has the following options: | ||
*''Input dataset | ====Input Parameters==== | ||
*''If condition'' | *''Input dataset'' – Select which dataset in the project will be filtered to create the new dataset. | ||
*''If condition'' – select the filtering criteria that will be used. Options include: | |||
**< (less than) | **< (less than) | ||
**<= (less than or equal to) | **<= (less than or equal to) | ||
| Line 20: | Line 21: | ||
**false (0.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). | **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). | ||
*''Assign on false'' – If the value passes none of the criteria, a default value can be assigned as per follows: | |||
**original (no change) | **original (no change) | ||
**specify (a user specified value) | **specify (a user specified value) | ||
| Line 27: | Line 28: | ||
**true (1.0) | **true (1.0) | ||
**false (0.0) | **false (0.0) | ||
====Output Parameters==== | |||
*''Output dataset'' | *''Output dataset'' – Enter the name for the filtered dataset | ||
{{-}} | |||
<noinclude>[[Category:Toolbox Datasets]]</noinclude> | |||
<noinclude>[[Category: | |||
Latest revision as of 20:45, 25 October 2023
Filter Dataset Values
This tool allows creating a new dataset based on specified filtering criteria. 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. The tool has the following options:
Input Parameters
- Input dataset – Select which dataset in the project will be filtered to create the new dataset.
- If condition – select the filtering criteria that will be used. Options include:
- < (less than)
- <= (less than or equal to)
- > (greater than)
- >= (greater than or equal to)
- equal
- not equal
- null
- not null
- Assign on true – 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).
- Assign on false – If the value passes none of the criteria, a default value can be assigned as per follows:
- original (no change)
- specify (a user specified value)
- null (the dataset null value)
- true (1.0)
- false (0.0)
Output Parameters
- Output dataset – Enter the name for the filtered dataset
