Filtering Job Titles from Imported CSV Data in Existing Table

·

Ive build a table off of a imported CSV but am struggling to filter by job titles once the people table is built. Any advice for quickest way to filter without building another table from company data?

5 comments

Channeled
APP
·
·
You can filter your imported CSV table by job titles using the built-in filter function: 1. Select the filters button at the top of your table 2. Click + Add filter 3. Select the job title column from the dropdown 4. Choose a comparison operator (like "equal to" or "contains") 5. Enter the job title value you want to filter by You can add multiple filters with AND/OR logic if needed.
Source: Customize your table view | Documentation | Clay University
Richard D.
·
·
right but i need to filter out 20-50 job titles going one by one is painful
Channeled
APP
·
·
You can use filter groups to efficiently handle multiple job titles: 1. Click the Filters icon above your table 2. Select "+ Add filter group" 3. Choose "OR" as the group logic (so any matching title will be included/excluded) 4. Add multiple filters for the job title column using "+ Add filter" 5. For each filter, select "equal to" or "contains" and enter a job title This approach lets you filter by multiple job titles at once without creating a new table.
Sources: Customize your table view | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns
Richard D.
·
·
Okay but that means i have to enter dozens of manual titles and create a filter for each one?? cant i do a Title, title,title???
Richard D.
·
·
https://app.clay.com/workspaces/547212/workbooks/wb_0sxe6rhhU2cvNhWUFbu/tables/t_0sxngerDfYaprbbtyT3/views/gv_0sxngesfMUQ3AaUqNZJ