Clay Icon

Hi folks, any idea how I can properly filter out these empty rows?

·
·

Hi folks, any idea how I can properly filter out these empty rows?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To filter out empty rows in Clay, you can use the Filter feature: 1. Click "Filter" above your table. 2. Select the column you want to filter. 3. Choose "is not empty" as the condition. This will hide rows with empty cells in the selected column. You can apply multiple filters for different columns if needed. If you still see empty rows after filtering, it might be a temporary display issue. Try clearing your cache and refreshing your screen to resolve it. Need more help? Just ask to talk to a person in this chat.

  • Avatar of Peter F.
    Peter F.
    ·
    ·

    Human

  • Avatar of Peter F.
    Peter F.
    ·
    ·

    Have tried that

  • Avatar of Stefano
    Stefano
    ·
    ·

    Hi Peter, thanks for reaching out! One way to remove the empty rows is by creating a filter based on a column that you know will always have a value. For example, you could set a filter where "Person - ID" is not empty. This will return only rows with data in that column. Let me know if this helps!

  • Avatar of Peter F.
    Peter F.
    ·
    ·

    Thats’ what I had been trying — if you look at the screenshot you’ll see that I filtered down to onlly rows where the checkbox was not clicked and it didn’t work properly

  • Avatar of Stefano
    Stefano
    ·
    ·

    Could you please try using the "Person - ID" is not empty filter? There could be an issue with the check-box filters!

  • Avatar of Peter F.
    Peter F.
    ·
    ·
  • Avatar of Stefano
    Stefano
    ·
    ·

    Hi peter, fro you mind refreshing your page? When I look at your table, it seems like all your rows have information in them:

    (451 kB)
    Image
  • Avatar of Peter F.
    Peter F.
    ·
    ·

    Interesting, I see the same. Any idea what changed?

  • Avatar of Stefano
    Stefano
    ·
    ·

    Likely a glitch on your interface. Especially with larger tables, sometimes there is a lot of data to load and the systems do not display it correctly. When you apply filters and do not see the desired results, always make sure to refresh the page, ensuring it is not a UI issue :)

  • Avatar of Peter F.
    Peter F.
    ·
    ·

    To be clear I had refreshed multiple times

  • Avatar of Peter F.
    Peter F.
    ·
    ·

    I do suspect this was on the “clay side” but nonetheless seems like this is fixed and I’ll follow those debugging steps in the future if I see UI issues

  • Avatar of Stefano
    Stefano
    ·
    ·

    Understood! Sorry about the issue. In the meantime, is there anything else I can help you with? :)

  • Avatar of Peter F.
    Peter F.
    ·
    ·

    Nope appreciate it!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback ​Peter F.​!