| | {info}This guide will help you learn how to perform comparison-based filtering with the Greater Than function. |
| | {info} |
| | |
| | h4. To compare a variable with a constant, |
| | |
| | # Configure data sources and outputs and provide mapping, as shown in the picture below: |
| | \\ |
| | \\ !s1.PNG!\\ |
| | \\ |
| | # Double-click on the operation node (Filter, Transform, or Validate). |
| | # From the left, drag-and-drop the field to be compared onto the work panel. |
| | \\ |
| | \\ !s2.PNG!\\ |
| | \\ |
| | # Switch the functions panel in the right to the Number tab. |
| | # Drag-and-drop the GreaterThan function to the work panel. |
| | # Map the field with the function. |
| | \\ |
| | \\ !s3.PNG!\\ |
| | \\ |
| | # Double-click on the Greater Than node. |
| | | # Specify a number, or a string, or a date for the source field to be compared with. |
| | | # Specify a number, or a string, or a date for the source field to be compared with. \\ |
| | \\ !s4.PNG!\\ \\ |
| | {note}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_ |
| | {note} |
| | # Click Ok. |
| | # 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. |
| | |
| | !s5.PNG! |
| | |
| | h4. To compare two variables, |
| | |
| | # Configure data sources and outputs and provide mapping. |
| | # Double-click on the operation node (Filter, Transform, or Validate). |
| | # From the left, drag-and-drop the two fields that you want to compare with each other. |
| | \\ |
| | \\ !sb1.png!\\ |
| | \\ |
| | # Switch the functions panel in the right to the Number tab. |
| | # Drag-and-drop the GreaterThan function to the work panel. |
| | # Map the fields with the function. |
| | \\ |
| | \\ !sb2.PNG!\\ |
| | \\ |
| | # 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. |
