Table Lookup

This block must be linked to the Table block using the return value from the lookup, for example, Customer Name from CustID. CustID can be a variable populated in a Get Digits block.

You can configure the Table Lookup block to use the value of the variable CustID to lookup the matching Name for the row with a matching CustID column value.

Properties	Values	Description
Table Name	Text	Select from the list of tables in the workspace. See Manage tables.
Key Column Name	Text	Name of column to search for matching value.
Key Column Value	Text	Value to match in Key column
Lookup Col. Name	Text	Column name for return value.
Lookup Col. Value	Text	Variable to populate with Lookup Column Name for row matching Key Column Value.