Range to Sequence

Overview

The Range to Sequence macro converts low/high number ranges into sequences of numbers, written to a single VALUE field. For example, given these low/high pairs:

1,3

2,4

3,5

Range To Sequence would produce this output column:

1

2

3

2

3

4

3

4

5

Range to Sequence macro configuration parameters

The Range to Sequence macro has a single set of configuration parameters.

Parameter

Description

Low field

Field containing low values.

Default: none

High field

Field containing high values.

Default: none

Output field

Field to receive numeric sequence.

Default: VALUE

Configure the Range to Sequence macro

Select the Range to Sequence icon.
Go to the Configuration tab on the Properties pane.
Select Low field and choose the field containing the low values.
Select High field and choose the field containing the high values.
Optionally, select Output field and specify a name for the sequence output field.
Optionally, go to the Execution tab, and then set Web service options.