Clay Icon

Filtering Columns for Non-B2B Values: A Quick Guide

ยท
ยท

how do i filter and remove for any values that are not "b2B" in a column. Ive done it before by doing bolean but i cant find it

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    To filter out any values that are not "b2B" in a column:1. Click the "Filters" button at the top of your table 2. Click "+ Add filter" 3. Select your column from the dropdown 4. Choose "equal to" as the comparison operator 5. Enter "b2B" as the valueThis will show only the rows where the selected column exactly matches "b2B".Note: The filter is case-sensitive, so make sure to match the exact capitalization of "b2B" as it appears in your data. Sources: Customizing your table view | Documentation | Clay University Comparison operators | Documentation | Clay University

  • Avatar of hanad c.
    hanad c.
    ยท
    ยท

    I'm not seeing the "equal to"

  • Avatar of hanad c.
    hanad c.
    ยท
    ยท

    here's my table

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    When adding a filter for your column, you'll find the "equal to" option in the comparison operator dropdown after selecting your column. Here's how to find it:1. Click the "Filters" button at the top of your table 2. Click "+ Add filter" 3. Select your column from the dropdown 4. Look for the comparison operator dropdown - "equal to" should be one of the first options availableSince you're filtering for text values, "equal to" (==) will check if the text matches your specified value "b2B" exactly. Remember that this is case-sensitive, so make sure to match the exact capitalization of "b2B" as it appears in your data. Sources: Customizing your table view | Documentation | Clay University Comparison operators | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of hanad c.
    hanad c.
    ยท
    ยท

    when i click the column i want to filter, the options become "has error" "result not found" and so on

  • Avatar of hanad c.
    hanad c.
    ยท
    ยท

    The "not equal to" goes away

  • Avatar of Owen C.
    Owen C.
    ยท
    ยท

    Hey Hanad, thanks for reaching out! This issue occurs because you're trying to filter the AI column directly instead of filtering the response generated by it. To resolve this, map the response data into a new column and apply your filter to that new column. Let me know if you need further assistance! :)

  • Avatar of hanad c.
    hanad c.
    ยท
    ยท

    legend

  • Avatar of hanad c.
    hanad c.
    ยท
    ยท

    worked

  • Avatar of Owen C.
    Owen C.
    ยท
    ยท

    Appreciate you Hanad! Let me know if you have any other questions here. :)

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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