The TO and BY operators can be used to create an
expression that returns an array of integers.
The expression should be structured as
follows:
first_value TO last_value BY incrementNote: In Talend Data Mapper, the
BY clause is optional. If it is absent, the default increment is
1 if the second value is greater than the first value, and
-1 if the first value is greater than the second value. For example,
the query SELECT 1 TO 5 returns [1, 2, 3, 4,
5].The values specified can be an integer or any identifier or expression that can be
interpreted as an integer. For example:
FROM in
LET $first = 5
SELECT $first TO ($first * 5) BY 2With the query above, the following result is
returned:
[[5,7,9,11,13,15,17,19,21,23,25]]