The combination rule produces CSV records from the values of its children like a Concatenate does. But in the case of the combination, the rule produces a sequence of records where each field of the record will take a predefined number of values from the associated child.

combination generation

The total number of records in a sequence of a combination is equal to the product of the number of values to be taken by each field.

For example, consider a combination with 2 children field, one that produces the values "A", "B", "C" and "D" and another field that produces the values 1, 2, 3 and 4.

The combination configured with a ":" as separator and 3 values from the first child and 4 values for the second child will produce sequence of 4 * 3 = 12 values build this way :

C:4 <- end of a sequence generated by the combination
A:1 <- restart the sequence for next record

The memory foot print of a combination is the sum of the number of values for each child.

Add comment

Security code