KV

Key/Value object. This function is used to pass parameters to multiple functions.

You can override the Data Source properties with a FROM parameter i.e. you can pass in your own SQL Query through a KV function. For example

LOOKUPA("CompanyName",FROM(KV("Command","SELECT SupplierID, CompanyName FROM Suppliers")), KV("SupplierID",SupplierID))

You can also chain the conditions where you need to match on multiple values i.e.

LOOKUPA("CompanyName","Suppliers",KV("SupplierID",SupplierID),KV("Country","UK"))

Syntax

KVAL KV(object key, object value)
KVAL KV(string key, string value)
KVAL KV(int key, int value)
KVAL KV(int key, string value)
KVAL KV(string key, int value)