Entrar Agende uma Demo Agende uma Demo
Back To Templates
inicianteInício fácil

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

serviços financeirossugerido

Teste A/B

Descubra uma maneira simples de atribuir um grupo de teste para realizar testes A/B em suas decisões.

Explore
serviços financeirossugerido

Precificação baseada em risco

Descubra uma maneira simples de aplicar uma matriz de precificação baseada em risco adequada ao tipo de cliente.

Explore
serviços financeirossugerido

Critérios de Elegibilidade e Regras da Política

Descubra uma maneira simples de definir e executar vários conjuntos de regras e obter o resultado da decisão final.

Explore