trying to do a table lookup in this workbook to pivot some columns from account to a people table and for whatever reason the "Lookup Single Row in Other Table" enrichment isn't recognizing the account table....here's a link to the workspace: https://app.clay.com/workspaces/420084/workbooks/wb_0sy0lnkYxzoaSPxWn23/tables/t_0sye9d5jT56gnGr7bpp/views/gv_0sye9d6iQtEmgSdQj3Z
There are a few possible reasons why the lookup isn't recognizing your account table: 1. You may need to re-run the company row in your people table first. Sometimes newly created columns or tables aren't immediately visible in formulas until you force a refresh. 2. Check if you've reached the maximum of 10 connected tables across your workbooks, as this could prevent new connections. 3. Ensure you've correctly selected the account table in the "Table to Search" field when setting up your lookup. If these steps don't resolve the issue, please share more details about your specific setup.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.