Range TablesLast Updated: September 09, 2019
Range Table allow users to create a table with two special columns: lower bound and upper bound. Users can then reference Range Tables in a range_lookup function. The range_lookup function will identify into which range a value falls and return any matching column the user wants.
Create Or Update Range Tables
You create Range Tables in Spiff Designer by clicking on the Table icon:
Once here, you click on the "Add New Table" button at the bottom of the page. Then select "Range Table".
From here, you can create the name of your table and specify the lower and upper bounds as well as any other custom return values for each table row.
To create custom values for new columns click on the arrow at the top of the column like this and insert a new column:
You can also change the name of custom columns by clicking on their name.