RANGE
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 or DATE values.
The column cannot 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:
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. Therefore a range with start 1 and stepsize 1 is created and then multiplied by 0.5: | ||||||||||
| ||||||||||
|