RANGE
Applies to: CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
With RANGE, a column which is not related to any table in the Data Model, can be created. It is filled with a range of INT, FLOAT or DATE values.
The column can not be joined to any table. It still can be useful to score a range against a machine learning model though.
Syntax
RANGE ( start_value, step_size, step_count )
Step size for date constants
If the start value is a date, the following options are available to define the range:
s: One second
m: One minute
h: One hour
D: One day
M: One month
Y: One year
Examples
[1] Create a range of INTs which starts at 0 and adds four rows in each of which the previous value is incremented by 1.
|
[2] Create a range of DATEs which starts at 01.01.2009 and adds four rows in each of which the previous date is incremented by 1 month.
|
[3] Create a range of FLOATs which starts at 0.5 and adds four rows in each of which the previous value is incremented by 0.5.
|