Table Parameter Expressions
TableParameter Functions allow you to build lookup functions by pulling data directly from Table Parameters. In the Expression Editor, use the Criteria helper panel to build your expressions:
Functions are available for each data type and the syntax is as follows:
TableParameterDate(Table, Field, Attribute, Key1, Key2,…,KeyN)
TableParameterDateSafe(Table, Field, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterText(Table, Field, Attribute, Key1, Key2,…,KeyN)
TableParameterTextSafe(Table, Field, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterValue(Table, Field, Attribute, Key1, Key2,…,KeyN)
TableParameterValueSafe(Table, Field, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterDate(Table, Field, Attribute, Key1, Key2,…,KeyN)
TableParameterDateSafe(Table, Field, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterText(Table, Field, Attribute, Key1, Key2,…,KeyN)
TableParameterTextSafe(Table, Field, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterValue(Table, Field, Attribute, Key1, Key2,…,KeyN)
TableParameterValueSafe(Table, Field, Attribute, SafeValue, Key1, Key2,…,KeyN)
Where N is the number of keys. If there are no Keys in the Table Parameter, you don’t need to pass in any keys.