Filter Dataset Tool

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