Lookup Rows

The Lookup Rows feature allows you to search and retrieve data from other tables in your workspace, enabling connections between tables and filtering data based on specific criteria.

Whether you need a single row or multiple matching records, these lookup actions provide flexible options to enhance your data management and create more dynamic, interconnected workflows.

Action Lookup Single Row in Other Table

Use this action to look up a single row from another Clay table. table. Although limited to a single row, this action will operate faster than a multiple row lookup.

Inputs:

• Table to Search
• Target Column
• Filter Operator
• Row Value

Action Lookup Multiple Rows in Other Table

Use this action to look up multiple rows in another Clay table.

Inputs:

• Table to Search
• Target Column
• Filter Operator
• Row Value
• Limit (Optional): The maximum number of rows to return.
  • This is useful to cut down on the response size if you have a large number of columns.