Filter Dataset Values Tool

From XMS Wiki
Revision as of 21:02, 31 January 2022 by Rcorrigan (talk | contribs) (Created page with "__NOINDEX__ {{Version SMS 13.2}} {{Filter Dataset Values}} {{Navbox SMS}}")

(diff) ← Older revision | Approved revision (diff) | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search


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