Clay Icon

Filtering Contacts by Existing Account IDs: A Step-by-Step Guide

ยท
ยท

I have a list of account IDs. I also have lists of contacts with relative Account IDs. How do I filter the contact lists to only contain contacts that have account IDs that exist on the separate list?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can use Clay's filtering functionality to accomplish this:1. Click "Filter" above your table 2. Select the Account ID column you want to filter 3. Choose "equal to" or "contains" as the operator 4. Enter the Account ID value you want to matchFor multiple Account IDs, you can add additional filters by clicking the "+" button and repeating the process with different Account ID values. Source: Hide, Re-order, Sort, Filter, Merge Columns

  • Avatar of James Z.
    James Z.
    ยท
    ยท

    Can I comma separate the account IDs?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, you can use comma-separated values in the filter. When using the Filter List of Objects function:1. Select the Account ID column as your "Filter Field" 2. Choose "Contains Any Of" as your Filter Mode 3. Enter your Account IDs as comma-separated values in the "Value(s)" fieldThe filter will match any records where the Account ID matches any of the values in your comma-separated list. Sources: Filter List of Objects with Clay Comparison operators | Clay University

  • Avatar of James Z.
    James Z.
    ยท
    ยท

    Is there a limit as to how many characters that row can contain?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, there is a limit of 8000 characters per cell/text field in a table. This limit would apply to the filter value field as well.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi James Z.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: