CAS 6

table
- Miscellaneous

Summary

Look up value in a table based on row and column keys. If row or column does not exist, pad with zero or blank. If only one key specified, select from the dimension that has multiple items.

Examples

'RATING' table 'AAA+' 'MOODY'

Syntax

'TableName' table RowOrKey ColumnKey (RangeLookup)

Left Arguments

Name	Data Type	Input Type	Description	Optional	Default
TableName	Text	Field, Constant	Name of User	No

Right Arguments

Name	Data Type	Input Type	Description	Optional	Default
RowOrKey	Text	Field, Constant	Table Row	No
ColumnKey	Text	Field, Constant	Table Column	No
RangeLookup	Numeric	Field, Constant	Table Column	Yes	0=Find closest match, 1=find exact match or return 0, 4=Previous non-zero match, 5 Next non-zero match If not specified 0 by default for numeric, 1 by default for text

Result

Type: Text

Table value corresponding to row and column