Assign Value To Range – Openprise

Assign a numerical value to a range based on ranges defined in reference data.

Assign value in: Select attribute to assign range value to – can be numeric or a range (example: 1-100).
to a ranges specified in – data source which contains range definitions.
Minimum <operator> <field> – Minimum values defined in the reference data source for ranges.
Select Attribute: Attribute that contains the range value.
Maximum <operator> <field> – Maximum values defined in the reference data source for ranges.
Select Attribute: Attribute that contains the range value.
Write normalized range value – the range label text value defined in the reference data source for ranges.
to – the attribute where the resulting range value will be written.
If source data is already a range – Ignore, copy source data to output, or reassign using input range's min, max or average value.
If source data is not a number or a range – Copy source data to output or set output to empty value.
If source data is not in any range: Copy value from source, Replace attribute with a blank value, Retain the existing output value.

You can specify the boundary conditions to be either >, >=, <, or <=. Once you specify one boundary condition, the other boundary automatically sets to avoid any gap.
You can do assignment for multiple attributes in one task by creating separate actions, using the same range reference data or different range reference data.
If your source data is a range, replace "to" with "-" and strip out any additional words before using the task. For example, transform "500 to 1000 employees" to "500-1000".
Your range reference data source must contain these attributes: name of the range, minimum boundary of the range, and maximum boundary of the range.

Segment company size by employee count.
- Assign employee = 541 to range “500 to 1000 employees".

Segment company size by annual revenue.
- Assign revenue = $603 millions to range “$500M to $1B".

Related articles