|
|
|
|
|
|
Description
Return a value from a cached lookup sheet downloaded from pasPortal.
Arguments
1.Lookup - Name of the Macro.
2.Table Name - The name of the cached lookup as defined on the job definition.
3.Required - If true the a value must be found in the lookup table or an exception is thrown.
4.Value Column - The name of the column in the cached lookup table to return a value from.
5.Search Column 1 - The name of a column in the cached lookup table to search for a value in.
6.Search Value 1 - The value to search for in Search Column 1 to locate the row that contains the value to return from the Value Column.
7.Search Column N - The name of a column in the cached lookup table to search for a value in.
8.Search Value N - The value to search for in Search Column N to locate the row that contains the value to return from the Value Column.
Examples
<Lookup|Property|true|PropertyName|PropertyCode|101>
Scans a cached lookup table named Property for a value of 101 in the PropertyCode column and returns the value of PropertyName from the first row that matches.
Copyright © 2024 pasUNITY, Inc.
Send comments on this topic.
