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.
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]
Is that what you were looking for?
Is the lookup limited to 100 results? I have 11k rows in the other table
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]
Did that answer your question?
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"
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.
Was that helpful?
is not empty is not an optiuon. the only opptions are equals or contains
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]
Is that what you were looking for?
what about line cook then?
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.
Did that answer your question?
what if I comma sepaarted every letter of the alphabet, would that work or would it match incorrecrly
