Lookup

Description

Performs a lookup against a cached data table.

Arguments

1.Lookup - Name of the Macro.

2.Table Name - Name of the cached data table to search against.

3.Required - A value (either True or False) that determines the behavior if a value is not found. If no value is found and the Required is True an error will be raised.

4.Value Column - The name of the column that contains the value to return.

5.Search Column 1 - Name of the column to search for the source value in.

6.Search Value 1 - The value to search the Search Column for.

7.Search Column n - Name of the column to search for the source value in when using multiple column search.

8.Search Value n - The value to search the Search Column for when using multiple column search.

Examples

Searches the DOW (Day of Week) table for a value in the DayName column when the ZeroBased column contains a value of 1.

Searches the DOW (Day of Week) table for a value in the DayName column when the ZeroBased column contains a value of 1 and the Property column contains a value of 21.

Notes

If multiple rows are found that meet the search criteria, an error occurs.

If the function contains a reference to a property or attribute that does not exist, an error occurs.

If Required is set to False and the syntax is valid but no matches are found, a blank value is returned.

If Required is set to True and the syntax is valid but no matches are found, an error occurs.

In order to access a lookup, it must have either been selected as an option during pasTransfer configuration or loaded using the [Option|LookupName] macro. When using pasPortal as the mapping provider the option can contain multiple lookup sheets as long as they are separated by a semi-colon [Option|LookupOne:LookupTwo:LookupThree].

Send comments on this topic.