Home > Predictive Query Nodes > Prediction Query > Edit Prediction Query > Add Partitioning Columns > Add Partitioning Expressions
To specify a patitioning expression, click . Then use Expression Builder to create an expression.
Suppose that one of the partitions is AGE. Here is a sample partitioning expression:
CASE WHEN AGE < 20 THEN 1 WHEN AGE >=20 AND AGE < 40 THEN 2 WHEN AGE >=40 AND AGE < 60 THEN 3 ELSE 4 END
Suppose that this expression is named Expression_1
. After you run the node, the output includes a column titled Expression_1
. This column will contain the value 1
if AGE
is less than 20
, 2
if AGE
is 20
or larger but less than 40
, and so forth.