AutoID Heater, generating consecutive numbers
The AutoID Heater enables you to generate a consecutive sequence of numbers automatically. The generation assigns the first record/row according to the Start parameter and increments the initial value for each record/row by the amount of the Step parameter. In the example below, the first record would be assigned 1, the second 2, the third 3, and so on.
Decimal accuracy is set by the Decimals parameter and the Step parameter can also cope with decimal fractions, making it possible to generate some extremely odd looking values. Of course, the AutoID Heater can also count backwards; to do this you simply enter a negative value in the Step parameter.
The output of the AutoID Heater can be used more than once (as many times as you wish). The output value remains the same until the next record is processed.
Ignore filtered records/rows: When you check this option, no AutoID values will be generated for records/rows that are filtered out. This avoids potential gaps in the consecutive numbers that are generated when data is filtered out. The default setting is to ignore filtered records.
Note: This option is only active when at least one Filter Heater is used in the Definition.
All: The number sequence is generated consecutively according to the processed records/rows of the WRITE Adapter. This is the standard setting.
Only every X records: When you check this option, the consecutive values generated are only incremented each time a specified number of records or rows is processed. Using this option it is fairly easy to create exports that are separated into several output files (split). See below for a video example of this.
Identical input parameter values: Consecutive numbers will be created when the input parameters are equal.
GroupBy (Heater): This option only becomes active if you have already used the GroupBy Heater in your Definition. If this option is selected, the sequence is reset for each group and effectively counts the grouped rows.
GroupOut (Heater): This option only becomes active if you have already used the GroupOut Heater in your Definition. If this option is selected, the sequence is reset for each group generated and labels the duplicates serially.
Notes on formatting and numbers of decimal places
If the output is subsequently processed as a string, the numbers generated are converted in accordance with the format configuration of the WRITE Adapter. Including the locale, this determines the symbol used for decimals (point or comma), the number of decimal places, whether the minus sign is a prefix or a suffix, and many other format options.
The AutoID Heater is used in the following examples:
- Simple data filter and grouping example
- Expert MS Excel CSV data export
- CSV export divided into several files