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.