.png){kind=logo}
Troubleshooting LookUp Single Row Function Data Issues
Hey team, LookUp single row function isn't pulling full data for some of the rows. how can I troublou shoot it?
To troubleshoot the Lookup Single Row function in Clay when it's not pulling full data for some rows, try these steps: 1. Check your inputs: Ensure the Table to Search, Target Column, Filter Operator, and Row Value are correctly set. 2. Verify data consistency: Make sure the data in your source table matches the lookup criteria exactly. 3. Review filter settings: Double-check your filter operator and row value to ensure they're appropriate for your data. 4. Consider using Multiple Rows: If you need more than one row, try the "Lookup Multiple Rows in Other Table" action instead. If the issue persists after trying these steps, request human assistance by clicking on "Talk to a person" for further support.
Andi D.··double checked the empty rows and the data exists in the target table, but just arent showing in the current table, force ran it a few times and no success Here's hte table: https://app.clay.com/workspaces/449716/workbooks/wb_ngji4EChmDo9/tables/t_FNwrmcnTtYue/views/gv_foPhwyihiM5G
To resolve the issue with the Lookup Single Row function not pulling full data for some rows, try these steps: 1. Clear your browser cache and refresh the screen. This can help resolve short-term front-end performance issues that might cause empty rows to appear. 2. Double-check your lookup settings: • Ensure the correct Table to Search is selected • Verify the Target Column is accurate • Confirm the Filter Operator is appropriate • Check that the Row Value is correct 3. If the issue persists, consider using the "Lookup Multiple Rows in Other Table" action instead. This might retrieve the data you're looking for, even if it's more than one row. If these steps don't resolve the problem, request human assistance by clicking on "Talk to a person" for further support.
- Andi D.··
Here's hte table: https://app.clay.com/workspaces/449716/workbooks/wb_ngji4EChmDo9/tables/t_FNwrmcnTtYue/views/gv_foPhwyihiM5G Many rows should be showing 16-18 rows of data from targetted table but are only showing 8 in current table. I went back to the target table and double checkeded, the data exist just aren't showing in current table image.png
Hey there Andi thanks for reaching out, taking a look at your table is there specific example were there is data that appears to be missing. To confirm this is for the lookup column called "Lookup Single Row" correct?
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.
- Andi D.··
yes LuisArturo for example, row 100, 104--107
- Andi D.··
it just happens randomly, these LookUp rows only retrieved 8 data points from target table VS other ones with full data retrieved 16