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.



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)