Lookups provide powerful capability to write data driven rules. Instead of coding every condition explicitly, lookups allow looking up values from a look table based on one or more keys.
A lookup table has one or more key columns, and one or more value columns. An example lookup table, where ‘member_tier’ and ‘booking_code’ are keys and ‘bonus’ and ‘point_bonus’ are value:
The example assumes ‘bonus’ is a discount rate and ‘point_bonus’ is additional points awarded to different members.
Instead of coding how to compute the bonus based on member_tier and booking_code in rules using expressions, it can be looked up from the above lookup table.
Note: Lookup tables are csv files, NOT XLS files.