Template:Filter Dataset: Difference between revisions
From XMS Wiki
Jump to navigationJump to search
m (Protected "Template:Filter Dataset" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))) |
|||
Line 9: | Line 9: | ||
**> (greater than) | **> (greater than) | ||
**>= (greater than or equal to) | **>= (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: | *''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: | *''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 Parameters==== | ||
*''Output dataset'' – Enter the name for the filtered dataset | *''Output dataset'' – Enter the name for the filtered dataset | ||
{{-}} | {{-}} | ||
<noinclude>[[Category:Tools]]</noinclude> | <noinclude>[[Category:Tools]]</noinclude> |
Revision as of 16:14, 17 March 2023
Filter Dataset
The Filter Dataset 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