Lookup

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

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.

Send comments on this topic.