Performs a lookup against a cached data table.
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.
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.
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].
Copyright © 2023 pasUNITY, Inc.
Send comments on this topic.