Clay Icon
Join the Community
02 Support

Need Help: Clay Table Producing Fewer Results than Expected

Avatar of Suzie W.Suzie W.
·
·

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?

4 comments

  • Avatar of Channeled
    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 .

  • Avatar of Prince A.
    Prince A.
    ·
    ·

    May be you can adjust your criteria to get more results. Some times including fewer keywords and profile input leads to less data.

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    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?