Template:Filter Dataset Values: Difference between revisions

From XMS Wiki
Jump to navigationJump to search
(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...")
 
No edit summary
Line 2: Line 2:
===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 tool has the following options:
*''Input dataset
*''If condition''
**< (less than)
**<= (less than or equal to)
**> (greater than)
**>= (greater than or equal to)
**equal
**not equal
**null
**not null


; Filter : This creates a new dataset based on specified criteria. The following options are available for filtering:
*''Assign on true'' &ndash; If the value passes the specified filter, the following can be assigned:
:*< (less than)
**original (no change)
:*<= (less than or equal to)
**specify (a user specified value)
:*> (greater than)
**null (the dataset null value)
:*>= (greater than or equal to)
**true (1.0)
:*equal
**false (0.0)
:*not equal
**time &ndash; 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).
:*null
In addition, if the value passes none of the criteria, a default value can be assigned (see available options above).
:*not null
*''Assign on false'' &ndash;
: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 &ndash; 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.
*''Output dataset''
 
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.




<noinclude>[[Category:Tools]]</noinclude>
<noinclude>[[Category:Tools]]</noinclude>

Revision as of 15:33, 6 August 2021

Filter Dataset Values

This tool allows creating a new dataset based on specified filtering criteria. The tool has the following options:

  • Input dataset
  • If condition
    • < (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).

In addition, if the value passes none of the criteria, a default value can be assigned (see available options above).

  • Assign on false –
    • original (no change)
    • specify (a user specified value)
    • null (the dataset null value)
    • true (1.0)
    • false (0.0)
  • Output dataset

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.

Retrieved from "https://www.xmswiki.com/index.php?title=Template:Filter_Dataset_Values&oldid=150252"