Parallel Lookup Strategy

This project demonstrates how to effectively utilize a Lookup Table within a workflow to perform multiple, distinct data retrieval functions based on a single key. The flow initializes necessary variables and then queries the Lookup Table to check for an object's existence, retrieve the full object's data, and extract a specific value.

Solution Components:

• The Lookup Table (Implicit Reference): This acts as the external data source or reference database that the flow queries. It contains the key records and columns used for all lookup operations.

• The Flow (The Execution Engine): This is the workflow itself, which sequences the logic for interacting with the Lookup Table:

  • Variables Node (declare): Initialises the primary key and the desired output column that define the lookup target.

  • Business Rule Nodes (The Lookup Operators): These nodes all reference the Lookup Table and demonstrate three primary lookup capabilities:

    • isObjectExist: Uses LOOKUP_EXISTS to perform a foundational Boolean check.

    • getObject: Uses LOOKUP_VALUE (with PK only) to retrieve the full data object (a complete record).

    • getValue: Uses LOOKUP_VALUE (with PK and output column) to retrieve a specific field value.

  • Data Manipulation Node (assignOutput): Collects and structures the varied results from the Business Rule lookups into the final workflow outputs (doesObjectExist, object, value).

Use this template to learn how to:

• Query a Lookup Table for Existence: How to use the LOOKUP_EXISTS function within a Business Rule to quickly verify if a primary key is present in the table.

• Retrieve Full Data Objects: How to use the LOOKUP_VALUE function with only the primary key to fetch an entire record from the Lookup Table.

• Extract Specific Values: How to use the LOOKUP_VALUE function with both the primary key and a column name to precisely retrieve a single data point from a record.