Lookup
Use <#Lookup> to search for a field description on another table.
Syntax
Parameters
table name: Master table where we will look for the value.
search key names: A list of columns containing the search key on the master table. It will normally be just one column, but if you need to search by more than one, you can separate column names with a comma (“,”)
search key values: A list of values containing the search values on the master table. The number of search key values should match the number of search key names. If you have more than one search key value, you need to use an <#array> tag.
result field: the field of “Table name” you want to display.
Example
If you keep an CustomerId on table Orders and the Customer data on a table Customers, to output the real customer name for an order you can use:
<#Lookup(Customers;CustomerId;<#Orders.CustomerId>;CustomerName)>
Last updated
