This guide will help you learn how to grab the records that are greater or equal to a specified value.
Configuration
To start the filtration,
Do the mapping and configure data sources and outputs
Double-click on the operation node (Filter, Transform, or Validate)
Drag-and-drop to the work panel the field that will be compared
Drag-and-drop the Greater Or Equal function
Map the field with the function
Double-click on the Greater Or Equal node
Specify a number (or date, or string) to compare 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
Click Ok
Close the filtration work panel
Preview
Now you can preview the result.
Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.