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 )
- start_value: Value range should start from (INT, FLOAT or DATE constant)
- step_size: How big should be a step in the range (INT, FLOAT or STRING constant)
- step_count: How many steps should be done on the START_VALUE (INT constant)
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
[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:
Query
Column1
RANGE ( {d '2009-01-01' } , '1M' , 3 )
Input
Output
Result
Column1 : DATE |
---|
Thu Jan 01 2009 00:00:00.000 |
Sun Feb 01 2009 00:00:00.000 |
Sun Mar 01 2009 00:00:00.000 |
Wed Apr 01 2009 00:00:00.000 |