Filtering Columns for Non-B2B Values: A Quick Guide

hanad canter · 2025-01-08 17:33:15.39739+00

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

Filtering Columns for Non-B2B Values: A Quick Guide | Clay

13 comments

· Sorted by Oldest

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
hanad canter
·
·
I'm not seeing the "equal to"
hanad canter
·
·
https://app.clay.com/workspaces/443186/workbooks/wb_XsJzGU8TojoF/tables/t_ssyqKSgPPdrQ/views/gv_8Fn8eUvAHapQ
hanad canter
·
·
here's my table
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
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!
hanad canter
·
·
when i click the column i want to filter, the options become "has error" "result not found" and so on
hanad canter
·
·
The "not equal to" goes away
owen (Clay)
·
·
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! :)
hanad canter
·
·
legend
hanad canter
·
·
worked
owen (Clay)
·
·
Appreciate you Hanad! Let me know if you have any other questions here. :)
Channeled
APP
·
·
Hi hanad canter! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

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
hanad canter
·
·
I'm not seeing the "equal to"
hanad canter
·
·
https://app.clay.com/workspaces/443186/workbooks/wb_XsJzGU8TojoF/tables/t_ssyqKSgPPdrQ/views/gv_8Fn8eUvAHapQ
hanad canter
·
·
here's my table
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
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!
hanad canter
·
·
when i click the column i want to filter, the options become "has error" "result not found" and so on
hanad canter
·
·
The "not equal to" goes away
owen (Clay)
·
·
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! :)
hanad canter
·
·
legend
hanad canter
·
·
worked
owen (Clay)
·
·
Appreciate you Hanad! Let me know if you have any other questions here. :)
Channeled
APP
·
·
Hi hanad canter! This thread was recently closed by our Support team. If you have a moment, please share your feedback: