Need Help: Clay Table Producing Fewer Results than Expected

Suzie W. · 2025-05-08T08:30:22.708929+00:00

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?

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

4 comments