How to Add Rows to a Table Without Duplicating Existing Data

Hi there! I ran the first 50 rows on my table and now I want to add the rest. How do I do that without duplicating the first 50 companies I generated and keep it in the same table?

✅1

28 comments

Clay T.
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Kobe G.
·
·
https://app.clay.com/workspaces/233174/tables/t_SMN2yUqRH7wH/views/gv_zSk5Q6b0t6BV
Clay T.
APP
·
·
Hey Kobe - when you import new companies it should auto-dedupe!
Kobe G.
·
·
it didnt auto-dedupe 😞
Kobe G.
·
·
is there a quick way i can filter out duplicates
Kobe G.
·
·
Matthew Q.
Matthew Q.
·
·
Oof sorry about that
Matthew Q.
·
·
just click on the linkedin URL column
Matthew Q.
·
·
then dedupe
Matthew Q.
·
·
just added some credits as well
Matthew Q.
·
·
if you need to do that again:
1.
Click the elipses
2.
Turn off auto-update
3.
Import new companies
4.
Click on the Linkedin URL column and dedupe
5.
Turn auto-update back on
Kobe G.
·
·
Thank you for that, but it is not the linked in url section, its just the company name
Kobe G.
·
·
my apologies im so new to this site
Matthew Q.
·
·
Ah gotcha, then yep use company name
Matthew Q.
·
·
all good!
Kobe G.
·
i don't see the de-dupe in the column
Matthew Q.
·
·
Kobe G.
·
·
thank you
Kobe G.
·
·
one last question. How do i filter out every company that doesnt have the technologies found i searched for
Matthew Q.
·
·
Right up here!
Kobe G.
·
·
yes but what options do I select
Kobe G.
·
·
?
Matthew Q.
·
·
Matthew Q.
·
·
You can filter based on the technologiesfound column
Matthew Q.
·
·
then set it to “Contains”
Matthew Q.
·
·
and enter the keywords
Kobe G.
·
·
awesome thank you so much for all your help. I know how to do this now so I wont bother with these dumb questions again lol. TyTy
Matthew Q.
·
·
Haha you’re chillin! Highly recommend checking out this to help as you’re getting started: https://docs.clay.com/start-here/using-clay