Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

Data generation

Description

This section includes data generation functions.

Data generation functions generate data which is not contained in the underlying datamodel. Available functions in this section are:

  • RANGE: This generates a range of INT, FLOAT or DATE values. It is not joined to any table, which is why it is usually only used in combination with a machine learning model.

  • RANGE_APPEND: This generates a range of INT or DATE values and appends it to the input column. As the result table is joined to the input column, it can be used together with other dimensions.