Table Lookup Compound

This block searches a data table using several conditions at once.

It works like the Table Lookup block, but instead of a single field comparison it takes a list of Query Terms that must all match.

Table: the table to search.
Wrap Around: when enabled, if find_index is greater than or equal to the number of matching rows, the first matching row is returned.
Query Terms: the list of conditions a row has to satisfy. Each term has a Field Name, an Operator (Equals, Not Equal, Greater Than, Greater Than Equal To, Less Than, Less Than Equal To) and a Value. Static values, variables, and settings are acceptable as values.
find_index: block parameter selecting which of the matching rows to return, starting from 0.

Record Found: executed when a matching row is found. The row's fields are available to the following blocks, along with row_index, the position of the row in the table.
Record Not Found: executed when no row matches. This connection doesn't transfer any data.

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