LOOKUPEX

Lookup a value from a dynamic data source. For example from an Excel Sheet, a CSV file or a Data Sync Project

Syntax

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

Example

To lookup from an Excel spreadsheet you can use the following:

LOOKUPEX("Name", FROMEXCEL("filePath"), KV("ID",ID))

To lookup from a CSV you can use the following:

LOOKUPEX("Name", FROMCSV("filePath"), KV("ID",ID))

To lookup from an existing Data Sync project you can use the following:

LOOKUPEX("Name", FROMDATASYNC("filePath"), KV("ID",ID))