question: I have a table with entries

question: I have a table with entries, auto-dedupe is enabled and I want to re insert same records, but keep the last version scenario: I have a company with latest funding date = 2020-01-01 and now I get the data again, but company have latest funding date = 2025-01-01 . I want to insert the csv records, existing and new records, but if already exist, keep the latest entry can this be achieved by using order by created date desc and then once imported, will it keep the recently added entry over the existing one?

19 comments

Channeled
APP
·
·
Here are the key ways to work with your Clay table:1. Customize Views and Data Display: • Switch between different saved views using the dropdown menu at the top • Show/hide specific columns through the Columns button • Rearrange columns by dragging them in the Columns menu • Apply filters to display only relevant data 2. Add and Modify Data: • Add new rows by clicking "+ New Row" at the bottom of your table • Create new columns using AI by selecting "Add Column" > "Add Column using AI" 3. Import Data: • Import data from CSV files • Add data through various sources like Salesforce or Find People • Map columns when importing to align data with existing table structure Sources: Table sources overview | Documentation | Clay University Customizing your table view | Documentation | Clay University Add Column Using AI & Add New Rows
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
LuisArturo
·
·
Hey there Esteban thanks for reaching out, how can we help you today?
Esteban L.
·
·
question: I have a table with entries, auto-dedupe is enabled and I want to re insert same records, but keep the last version scenario: I have a company with latest funding date = 2020-01-01 and now I get the data again, but company have latest funding date = 2025-01-01 . I want to insert the csv records, existing and new records, but if already exist, keep the latest entry can this be achieved by using order by created date desc and then once imported, will it keep the recently added entry over the existing one? (edited)
Mark L.
·
·
As you may have seen, Clay's auto-deduplication on the table keeps the oldest record, rather than the most recent one. (see https://www.clay.com/university/guide/configuring-your-table-settings#auto-dedupe) And today, Clay doesn't have any way of selectively updating a value in a given row. Can you share a bit more about the overall workflow you have in mind? How are records entering / how are they being used?
Esteban L.
·
·
ok you have a list of thousand of accounts name, website, that's it you export it import it into Apollo then download enriched list (csv) re-import back to Clay table ideally keep the last entry with updated info about technology, last funding date, etc
Esteban L.
·
·
keep the oldest record this is based on createdDate then, so sorting doesn't affect which record is kept
Esteban L.
·
·
so the oldest
Mark L.
·
·
Thank you. If the original Clay table only has a few columns, but the CSV includes those (+ many more), could you help me understand the value of the original Clay table? Presumably the CSV also contains name and website, so I'm curious why importing back to the original table is the next step. Just trying to understand the big picture!
Esteban L.
·
·
there is anoter table bigger master company table
Esteban L.
·
·
referencing this "apollo table"
Esteban L.
·
·
we don¿t want to use apollo details through API becuase API limits, and we need to get info rom thousand of accounts
Esteban L.
·
·
so idea would be have everything set
Esteban L.
·
·
and later just reimport same records within the apollo table
Esteban L.
·
·
then in the master table referencing the apollo table you would just need to Force to rerun Lookup relationship, that way now you will have updated data from apollo for all the records, accesible, up to date in the master table
LuisArturo
·
·
Hey there Esteban, jumping in for Mark here, have you tried using a Lookup Row in other tables to accomplish this. What you can do is re-import enriched list into a new Clay table and then in the original table use a Lookup Row in other table, to make a connection between both tables in order to bring in the enriched values back into the original table in the same rows as the other data for each entry without having to worry about creating duplicate rows for each value.
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Esteban L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: