Skip to main content

Table Lookup

This block performs a search in a given data table.

Table Lookup Block

Configuration

Table Lookup Block details

This block has the following configuration options.

  • Table: specify which Table should be used for the lookup
  • Wrap Around: when enabled, if find_index is greater than or equal to the number of resulting rows, the first resulting row will be returned
  • Field Name: the name of the field used to check each row
  • Operator: the function used to compare each row's field
  • field_value: the value to be compared
  • find_index: the index of the row to be returned (if this is higher than the number of rows returned, then the record will be determined to be not found)

Connections

The Table Lookup block has two connections:

Table Lookup block connections
  1. Record Found: Executed when a record is found. Furthermore, it allows the next block (or blocks) to use the fields in the row.
  2. Record Not Found: Executed when no record is found. This connection doesn't transfer any data.

For more information on how to use Data Tables, check out these docs.