Referencing a Large Job Title Keywords Table in a Separate Workbook

Ciaran E. · 2026-01-23T16:51:21.128Z

how can I have "job title keywords" reference a table with tens of thousands of rows, in a separate workbook? thought process = I have a sheet with hundreds of our buyer persona icp titles in a separate workbook, which I want to use in this workbook as job title keywords.

Referencing a Large Job Title Keywords Table in a Separate Workbook | Clay

Clay Support
APP
·
·
You can't directly reference another table's data in the job title keywords field, but here's a workaround:
Use the Lookup Multiple Rows in Other Table action to pull your job titles from your separate workbook into your current table. [1]
Set it up like this:
Table to search: your buyer persona table in the other workbook
Target column: the column with your job titles
This will return all matching job titles as a list [2]
Then you can copy those job titles into your job title keywords field. The lookup action lets you search and retrieve data from other tables in your workspace, which is perfect for connecting your ICP titles to your current workflow. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Ciaran E.
·
·
Is the lookup limited to 100 results? I have 11k rows in the other table
Clay Support
APP
·
·
No, there's no 100-result limit. The Lookup Multiple Rows action has an optional "Limit" field that lets you set the maximum number of rows to return, but this is completely optional. [1]
If you don't set a limit, it will return all matching rows from your 11k table. The limit is just there to help cut down response size if you have lots of columns, but you can leave it blank to get all results. [2]
Clay Support
APP
·
·
Did that answer your question?
Ciaran E.
·
·
ok. nice, and what's a universal title I can use here? like a,e,i,o,u? whats better? I want to say "is not blank"
Clay Support
APP
·
·
Change your Filter Operator from "Contains" to "Is Not Empty" instead of using a universal character. This will return all rows where the Job Title field has any value (not blank). [1]
The "Is Not Empty" operator is specifically designed for this - it identifies records where the field contains any value, which is exactly what you want for pulling all your job titles.
Clay Support
APP
·
·
Was that helpful?
Ciaran E.
·
·
is not empty is not an optiuon. the only opptions are equals or contains
Clay Support
APP
·
·
Got it! Since you only have "equals" or "contains" options, use "contains" with a single character that's likely to appear in most job titles. Try using just the letter "a" - it's the most common vowel and appears in most job titles like "Manager", "Analyst", "Sales", etc. [1]
This will effectively give you all rows where the job title field isn't blank, since almost every job title contains the letter "a". [2]
Clay Support
APP
·
·
Is that what you were looking for?
Ciaran E.
·
·
what about line cook then?
Clay Support
APP
·
·
You're right - "line cook" doesn't contain "a"! Try using a space character instead. Almost every job title has spaces between words, so using " " (space) as your search term will catch virtually all job titles including "line cook", "software engineer", "data analyst", etc. [1]
This gives you the broadest coverage for pulling all non-empty job titles from your table.
Clay Support
APP
·
·
Did that answer your question?
Ciaran E.
·
·
what if I comma sepaarted every letter of the alphabet, would that work or would it match incorrecrly

27 comments