This guide will help you learn how to perform comparison-based filtering with the Greater Than function.

To compare a variable with a constant,

1. Configure data sources and outputs and provide mapping, as shown in the picture below:
   
   
   
   
2. Double-click on the operation node (Filter, Transform, or Validate).
3. From the left, drag-and-drop the field to be compared onto the work panel.
   
   
   
   
4. Switch the functions panel in the right to the Number tab.
5. Drag-and-drop the GreaterThan function to the work panel.
6. Map the field with the function.
   
   
   
   
7. Double-click on the Greater Than node.
8. Specify a number, or a string, or a date for the source field to be compared with.
   
   
   
   

   At the moment, the following data types can be compared: Date and Number (Prior to comparison, the date is transformed into Unix time format and is compared in this format) Date and Date Number and Number Number and String

9. Click Ok.
10. Click Ok on the operation's work panel to quit the operation mode.

Now you can preview the results right-clicking on the target node and selecting Preview Results. Of the variables from the source tables mapped to the function, only those that are bigger than the specified constant will be sent to the output.

          

To compare two variables,

1. Configure data sources and outputs and provide mapping.
2. Double-click on the operation node (Filter, Transform, or Validate).
3. From the left, drag-and-drop the two fields that you want to compare with each other.
   
   
   
   
4. Switch the functions panel in the right to the Number tab.
5. Drag-and-drop the GreaterThan function to the work panel.
6. Map the fields with the function.
   
   
   
   
7. Click Ok to quit the operation mode.

Now you can preview the results right-clicking on the target node and selecting Preview Results. Of the two variables, the bigger one will be sent to the output.