Example: Series Generation
Generates series data by providing several parameters, like Step Size, Series Type, Period From and Period To.
Input Data
| Contract ID | Period From | Period To |
|---|---|---|
| A | 1 | 3 |
| A | 4 | 4 |
| Contract ID | Period From | Period To |
|---|---|---|
| B | 1 | 2 |
| B | 3 | 8 |
| Contract ID | Period From | Period To |
|---|---|---|
| A | 1 | 3 |
| Contract ID | Period From | Period To |
|---|---|---|
| A | 1 | 2 |
| A | 3 | 8 |
Flow Modeling Configuration
| Rule | Description | Rule Type | State | Rule Grouping | Rule Ordering | Selection |
|---|---|---|---|---|---|---|
| GS | Generate Series | Generate Series | Active | CONTRACT=“A” |
| Line | Incremented By | Minimum | Maximum | Series Type | Element Number | Fraction | Period From | Period To Result |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | PERIOD_FROM | PERIOD_TO | Integer | PERIOD_NUMBER |
Key Configuration Description
| Field | Meaning | Notes |
|---|---|---|
| Line | Identifier of the line | Must be unique. |
| Increment by | Field or single value that defines the number added to the value of the field Minimum. | Mandatory input |
| Minimum | Starting value of the series | Mandatory input |
| Maximum | Ending value of the series | Mandatory input |
| Series Type | Defines the type of input and affects the resulting output. |
Mandatory input.
Possible values:
|
| Element Number | The system writes the main result of the function to this fiedl. |
Mandatory output. You need to insert the target field in the Action tag of the Signature section. |
| Fraction | This field can be used to save an additional result of the function. | The following calculation is computed: Minimum value of the range/maximum value of the range. |
| Period From Result | This field can be used to save an additional result of the function. | Period From + Increment by |
| Period To Result | This field can be used to save an additional result of the function. | Period From Result + Increment by |
Caution
Depending on your individual data, the Series Generation rule type can add up to several hundreds or even thousands of new lines for each entry. This can have a significant impact on the performance. Using the general configuration and assigning input fields to the mapping fields (Increment by, Minimum and Maximum) allows you to process only a few hundreds of records. However, assigning constants to all three mapping fields instead allows you to process a significantly higher number of records.
Expected Result
| Contract ID | Period From | Period To | Period Number |
|---|---|---|---|
| A | 1 | 3 | 1 |
| A | 1 | 3 | 2 |
| A | 1 | 3 | 3 |
| A | 4 | 4 | 1 |
| Contract ID | Period From | Period To | Period Number |
|---|---|---|---|
| A | 1 | 3 | 1 |
| A | 1 | 3 | 2 |
| A | 1 | 3 | 3 |
| Contract ID | Period From | Period To | Period Number |
|---|---|---|---|
| A | 1 | 2 | 1 |
| A | 1 | 2 | 2 |
| A | 3 | 8 | 1 |
| A | 3 | 8 | 2 |
| A | 3 | 8 | 3 |
| A | 3 | 8 | 4 |
| A | 3 | 8 | 5 |
| A | 3 | 8 | 6 |
The three patterns are shown separately for clarity of exposition.