Purpose
Assign a numerical value to a range based on ranges defined in reference data.
Category Location: All, Calculate or manipulate
Field description
- 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.
Tips
- 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.
Examples:
Range Name |
Minimum |
Maximum |
|
|
|
|
|
|
|
|
|
Range Value |
Range Min |
Range Max |
|
|
|
|
|
|
|
|
|
Examples
-
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".