Understanding Deduplication: How New and Old Rows are Handled

·

When deduping a column will it delete the new row that's been added to the column or will it delete the old row? For example if i have a table with 30 rows they are all open jobs - and then i run another table to write new open jobs to this table but i want to get rid of duplicates - will deduping keep the original record or will it delete that one and keep the new one?

2 comments

· Sorted by Oldest

Channeled
APP
·
·
When using auto-dedupe, our system retains the oldest row and deletes any duplicate rows that come after it.For manual column deduplication, here are some important points to keep in mind: ** The process is based on exact string matches ** Deduplication is case-sensitive (e.g., "Clay" and "clay" are treated as different values) ** Extra whitespace is considered in matching (e.g., "Clay " and "Clay" are different) ** Deleted rows cannot be recovered, so please proceed with caution Sources: Configuring your table settings | Documentation | Clay University Table columns overview | Documentation | Clay University
Channeled
APP
·
·
Hi Leti B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Channeled
APP
·
·
When using auto-dedupe, our system retains the oldest row and deletes any duplicate rows that come after it.For manual column deduplication, here are some important points to keep in mind: ** The process is based on exact string matches ** Deduplication is case-sensitive (e.g., "Clay" and "clay" are treated as different values) ** Extra whitespace is considered in matching (e.g., "Clay " and "Clay" are different) ** Deleted rows cannot be recovered, so please proceed with caution Sources: Configuring your table settings | Documentation | Clay University Table columns overview | Documentation | Clay University
Channeled
APP
·
·
Hi Leti B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: