struggling to use the “lookup single row in other table” function as it keeps citing an error due to endless loop but table A and Table B aren’t connected to eachother via formula aside from sharing some data parameters
The "endless loop" error occurs because Clay doesn't allow circular data flows between tables. Even though you're using lookup functions rather than formulas, Clay still detects a loop in your data flow.
Data in Clay can only flow linearly (A → B → C), not in loops (A → B → A). If you need to reference data bidirectionally, you should:
1. Maintain a one-way "write to other table" connection in one direction
2. Use lookup functions in the opposite direction
This prevents the circular dependency that's causing your error.