Lookup Single Row in Other Table just spinning for minutes.

The "Lookup Single Row in Other Table" feature is designed to be faster than multiple row lookups, but if it's spinning for minutes, there might be an issue. Here are some steps to try: 1. Check your table size and complexity. Large tables or complex queries may take longer to process. 2. Verify your inputs: ensure the Table to Search, Target Column, Filter Operator, and Row Value are correctly set. 3. Try using the Force Run option in the table settings. This may help refresh the data and resolve processing issues. If the problem persists, you may want to request human assistance for a more in-depth investigation of your specific setup.

Sources: Lookup Single Row in Other Table with Clay Lookup Rows | Documentation | Clay University

Hey there Ted thanks for reaching out, sorry for the delay, this was related to an ongoing issue we were experiencing with loading in Clay. For your particular table this error cause the Lookup to be stuck in Queued. I have gone ahead and fixed this by first stopping the run and then while filtering for all the "Queued" rows in that Lookup column I have "Force Run: all of the rows to fix this.