Object Lookup & Deconstruction

This project demonstrates how to validate banking transactions and assign a fee multiplier based on the relationship between an input origin and a destination bank.

Solution components:

• A Lookup Table named Wire Router acts as a reference database, storing details for over 70 banks including Swift Codes, Bank Names, Countries, and Routing Methods.

• A Decision Table named Determine Fee Multiplier performs the logic. It verifies if the Swift Code exists, retrieves the destination country from the database, and compares it against the origin country to apply the correct fee (Standard vs. International surcharge).

Use this template to learn how to:

• Connect Tables: How to use the LOOKUP_VALUE function to search a Lookup Table using a specific key (Swift Code) and retrieve a full data object.

• Extract Data: How to use the PICK function to select specific attributes (like "Country") from the retrieved data object for use in your rules.

• Compare Data Sources: How to build logic that compares user input (Origin Country) against database values (Bank Country) to make dynamic decisions.