Skip to main content
Sign in

Assign Value To Range

  • Updated

Purpose

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

 

Category Location: All, Calculate or manipulate

 

Field description

4.png

  1. Assign value in: Select attribute to assign range value to – can be numeric or a range (example: 1-100).
  2. to a ranges specified in – data source which contains range definitions.
  3. Minimum  – Minimum values defined in the reference data source for ranges.
  4. Select Attribute: Attribute that contains the range value.
  5. Maximum  – Maximum values defined in the reference data source for ranges.
  6. Select Attribute: Attribute that contains the range value.
  7. Write normalized range value – the range label text value defined in the reference data source for ranges.
  8. to – the attribute where the resulting range value will be written.
  9. If source data is already a range – Ignore, copy source data to output, or reassign using input  range's min, max or average value.
  10. If source data is not a number or a range – Copy source data to output or set output to empty value.
  11. 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="or"><=. you="you" specify="specify" boundary="boundary" condition,="condition," the="the" other="other" automatically="automatically" sets="sets" to="to" avoid="avoid" any="any" gap.="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
small 0 100
medium 100 1,000
large 1,000 100,000

 

 

Range Value Range Min Range Max
<$100k 0 100,000
$100k to $500k 100,000 500,000
$500k+ 500,000 99,000,000

 

Examples

  1. Segment company size by employee count.
    • Assign employee = 541 to range “500 to 1000 employees".
  1. Segment company size by annual revenue.
    • Assign revenue = $603 millions to range “$500M to $1B".

 

 

Related articles