Template:Filter Dataset Values

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.