Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
  • Home
  • Documentation
  • Min - Max Heater, finding the smallest or highest from a list of numeric values

Min - Max Heater, finding the smallest or highest from a list of numeric values

Min/Max HeaterThe Min and Max Heaters output the lowest and highest values respectively from a list of two or more numeric input values. Non-numeric data types are automatically converted according to the format configuration of the WRITE Adapter.

 

The Heaters are able of process FlowHeater data types Integer, Decimal, Currency, Double, Date, Time and DateTime. The input data type (numbers or dates and times) is automatically detected, and a mixture of data types is permitted.

Min = lowest value

Max = highest value

 

Aggregation functions with the Min and Max Heaters

The Min and Max Heaters can also be used to determine the lowest and highest values from grouped rows of data.

 

Heater Min/Max ConfigHeater Min/Max Config

Effects on

per record/row (default): When selected the lowest or highest value of all input connections is returned for each record/row.


GroupBy: When the GroupBy Heater is used and this option is checked, the lowest or highest value of all records/rows of the current grouping is returned.

Complete process: When this option is chosen, the lowest or highest value of all records/rows in the complete run is returned. This option is especially of use, for example, for the header or footer rows of CSV text files, or alternatively as a stored Parameter for recall as an initial value in a subsequent run.

 

Please also refer to the general information on the use of Heaters (functions)