How to Add New Job Postings and Avoid Duplicate Imports

hi there, new use. Trying to figure out how to add new job postings to my existing table. Right now when I try to import more, it only imports the jobs that have already been imported. Is there a way to import only those jobs from the search that are not already in the table.

✅1

13 comments

Dominick C.
·
·
https://app.clay.com/workspaces/206908/tables/t_piIgUNw83ZEn/views/gv_jfTiV5UswJSL
Clay Team
APP
·
·
Hi, thanks for getting in touch! You can create an additional table with the same workflow and perform a lookup search to the first table, then if there is no match use the write table function to populate a new row with the new job, you can check this videos for some guidance: Here's a video and our docs page for Lookup Record!Write to table integration to extract a list of results into their own rows in a new table, here's a quick video: https://www.loom.com/share/841cc9c009194f1688bbd134b3e4f388
Dominick C.
·
·
Thanks Juan, is there any way to make this dynamic as more searches match my criteria. Basically what I’m trying to do is dynamically add companies who post for this particular job to the existing table without pulling in companies I already have in the current table.
Dominick C.
·
·
IE as companies post for SDR titles, I’d like to add them
Clay Team
APP
·
·
you can import more jobs in the landing table adding rows from a csv, then the lookup will compare them and will add those that are new using the write to table integration, into the table that performs enrichments (template)
cc7daff9-6791-4fb0-ab90-ddb8e30e86f5.png(7 kB)
Dominick C.
·
·
Gotcha, let me look into this now and see if I can figure it out
Dominick C.
·
·
okay, so I don't really want to import from a CSV, I want to do it from the find jobs feature
Dominick C.
·
·
Is it possible to do that dynamically?
Clay Team
APP
·
·
I'm afraid at this moment is not possible, but the team is working in the implementation of new features for this, soon this will be more dynamic
:thumbsup_all:1
Dominick C.
·
·
When I'm adding additional find jobs searches to my existing table, is there a way to cross reference against what I already have in the table so that I don't get charged credits for uploading jobs I already have in my existing list?
Clay Team
APP
·
·
Yes, use the look up function, I would target the linkedin urlYou can check this video on how to use the lookup function https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9
Dominick C.
·
·
thanks this is great. Weirdly though, I can't find the linkedin URL in the company one
Dominick C.
·
·
nevermind figured it out