Skip to main content

LOOKUPBINCREMENTAL

The LOOKUPBINCREMENTAL function is similar to the LOOKUPB function, with the key difference being that it works incrementally. This means that the function caches the result of each lookup so that the same value is not looked up multiple times, which can improve performance when dealing with large data sets.

The LOOKUPBINCREMENTAL function takes the same parameters as the LOOKUPB function: columnName, which is the name of the column to retrieve from the target, from, which specifies the data source to retrieve the data from, and keyValues, which is a key/value object used to specify the conditions for retrieving data from the data source.

Syntax

object LOOKUPBINCREMENATL(string columnName, string from, params KVAL[] keyValues)
object LOOKUPBINCREMENTAL(string columnName, LFROM from, params KVAL[] keyValues)

Examples

Looking up a Company Name Incrementally

Suppose you want to retrieve the CompanyName from your data target incrementally based on a SupplierID. You can use the LOOKUPBINCREMENTAL function to accomplish this as shown below:

LOOKUPBINCREMENTAL("CompanyName", "Suppliers", KV("SupplierID", SupplierID))

In this example, the LOOKUPBINCREMENTAL function is used to retrieve the CompanyName from the Suppliers data source based on a SupplierID value. The function caches the result of each lookup so that the same value is not looked up multiple times, which can improve performance when dealing with large data sets.

Looking up a Contact Name Incrementally

Suppose you want to retrieve the ContactName from your target data source incrementally based on a CustomerID. You can use the LOOKUPBINCREMENTAL function to accomplish this as shown below:

LOOKUPBINCREMENTAL("ContactName", FROM("Customers"), KV("CustomerID", CustomerID))

In this example, the LOOKUPBINCREMENTAL function is used to retrieve the ContactName from the Customers data source based on a CustomerID value. The FROM function is used to specify the data source to retrieve the data from. The function caches the result of each lookup so that the same value is not looked up multiple times, which can improve performance when dealing with large data sets.