Login Book a Demo Book a Demo
Back To Templates
beginnerEasy Start

Lookup Table

This flow illustrates the use of a lookup table. It serves as a ready-made currency conversion engine, drawing on a central repository of exchange rates to perform financial calculations.

DecisionRules

David Škarka

Template author

Lookup Table 1
The primary objective of this rule flow is to convert a specific monetary amount from a source currency to a target currency using the most current exchange rates stored within the system. It ensures data integrity by validating that both the source and target currencies are supported by the system before attempting any calculations.

Solution Components
The flow orchestrates data between the user input and a specialized lookup table to produce an accurate conversion.
  1. CurrencyRates (Lookup Table)
    • Purpose: Acts as the central database for all supported currencies and their cross-exchange rates.
    • Supported Currencies: USD, CZK, CHF, EUR, MXN, and INR.
    • Function: Provides the specific exchange rate multiplier based on the source currency and the target currency column.
  2. Business Logic Nodes utilize several key stages to process the request:
    • Validation (checkCurrencyFrom & checkCurrencyTo): Two parallel checks verify if the requested currencies exist in the CurrencyRates table.
    • Conditional Switch (currenciesValidity): An IF-statement that directs the flow based on validation results.
    • Data Retrieval (fetchExchangeRate): Uses the LOOKUP_VALUE function to extract the specific rate for the currency pair.
    • Calculation (convertAmount): Multiplies the input amount by the fetched exchange rate.
Check iconA checkmark inside a circle signifying "yes"Minus iconA minus inside a circle signifying "no"PROS IconA plus symbol representing positive aspects or benefits.CONS IconA minus symbol representing negative aspects or drawbacks.

More Templates

See Other Templates

financial servicessuggested

A/B Testing

Discover a simple way to assign a test group for performing A/B Testing on your decisions.

Explore
financial servicessuggested

Risk Based Pricing

Discover a simple way to apply a suitable Risk Based Pricing matrix based on a type of client.

Explore
financial servicessuggested

Eligibility and Policy Rules

Discover a simple way to define and execute various sets of rules and get the final decision outcome.

Explore