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.