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
**Equal
**not equal
**Not equal
**null
**Null
**not 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)
**Original (no change)
**specify (a user specified value)
**Specify (a user specified value)
**null (the dataset null value)
**Null (the dataset null value)
**true (1.0)
**True (1.0)
**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:
*''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)
**null (the dataset null value)
**Null (the dataset null value)
**true (1.0)
**True (1.0)
**false (0.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