Release notes for version 2.4.0 on July 23, 2012
Filter duplicates records out
Filter duplicated entries out
The Filter Heater has been extended to provide a powerful new function. Repeated (duplicate) records or rows in the READ data source can now be filtered out with the Filter Heater. And in order to detect duplicate record/rows the data source does not need to be sorted!
Skipping empty lines
A further useful function has been added to the TextFile Adapter to ignore empty lines when reading (importing) text files (CSV, TXT, Flat File).
Release notes for version 2.3.1 on May 26, 2012
Improved handling of default values
When the value of a field contains DBNULL, NULL or an empty string, the field’s default value defined in the FlowHeater Definition will now be used.
Release notes for version 2.3.0 on May 7, 2012
New numeric data type DOUBLE
The existing FlowHeater numeric data types INTEGER, DECIMAL and CURRENCY were optimized for financial mathematics to avoid the occurrence of rounding differences. A new data type DOUBLE is now introduced for the higher precisions required in scientific calculations. The FlowHeater DOUBLE data type can process the SQL data types of float, real, single and double.
Release notes for version 2.2.6 on April 10, 2012
New export option for the TextFile Adapter
The TextFile Adapter has supported appending to existing text files on the WRITE side (export) for some time. Until now column field names were never added a second time to an existing text file. As of this version you can specify, in the case of appending to an existing file, whether column headings should be suppressed or not.
Release notes for version 2.2.5 on January 30, 2012
Calculations on date and time fields
New AddDays Heater
Using the AddDays Heater values can be added to date and time fields, or when negative, subtracted from them. Calculating with days, as suggested by the name of the Heater (function) is not all. By amending the default option in the configuration popup, you can also offset dates by years or months and times by hours, minutes or seconds.