Assign Value to Range



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


Field description

  • Assign value in – Input value – 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.
  • Maximum <operator> <field> – Maximum values defined in the reference data source for ranges.
  • 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 value, or reassign using the input data range’s min, max or average.
  • If source data is not a number or a range – Copy source value or set output to empty 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, 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.

    Range NameMinimumMaximum
    Range ValueRange MinRange Max
    < $100K0100,000
    $100K to $500K100,000500,000
    $500K +500,00099,000,000




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


Support Contacts

If you have any additional questions, please feel free to contact us at