Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Need Help: Clay Table Producing Fewer Results than Expected

·

·

Hi team - One of my clay tables is giving very few results. It is giving way fewer rows than expected. We expected about 1500 but are getting only 20. What can I do to get the desired outcome? Can anyone please help?

Need Help: Clay Table Producing Fewer Results than Expected | Clay

4 comments

· Sorted by Oldest

Channeled
APP
·
·
If your Clay table is returning fewer rows than expected, here are some steps to troubleshoot and potentially resolve the issue: ** Check Lookup Settings: If you're using the "Lookup Multiple Rows in Other Table" action, review the filter criteria (target column, filter operator, row value) to ensure they match the data you want to retrieve. Also, check if a "Limit" is set, as this restricts the number of rows returned. Removing or increasing this limit may help you get more results . ** Display Settings: Click on "Rows" at the top of your table and ensure the "Row Limit" is set high enough. You can also use "Show All Rows" to display the full dataset . ** *Data Filters: Make sure there are no filters applied that could be hiding rows. If you still can't retrieve the expected number of rows, you can request human assistance by clicking on "Talk to a person" in this chat .
Sources: Lookup Rows | Documentation | Clay University Format Rows Lookup Rows | Documentation | Clay University
Suzie Walker
·
·
https://app.clay.com/workspaces/265228/tables/t_0svxmjb7BP6yAgmkABM/views/gv_X97JN8FJAEwT
Arshad
·
·
May be you can adjust your criteria to get more results. Some times including fewer keywords and profile input leads to less data.
owen (Clay)
·
·
Hey Suzie, thanks for reaching out! When you say your team has expected about 1500 people, where did this number come from? Also, when looking at this table now there are ~1009 rows. Curious, did you end up expanding your search criteria? or what did this look like exactly?