Eg., In a table of social media data the content is duplicated, but the dedupe block doesn’t allow me to group content then choose to keep only the most recent.
If you’re looking to keep the most recent record by creation time and you don’t need to do any complex merging, you can actually do this with the dedupe block by using the sort feature.
If you sort by “Newest first”, you can use keyboard shortcuts to quickly process your records:
- Press 1 to select the first record in each set
- Press A to use that record as the primary record
- Press Cmd + Enter to delete the other records
The sort criteria will be preserved for each set of records, so you’ll always keep the latest record. This isn’t quite as efficient as a script that automatically deduplicates all records as a bulk operation, but it may be sufficient for your needs in the meantime.