Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 20, 2024 10:34 AM - edited Aug 20, 2024 10:37 AM
Hello,
I'm trying to perform duplicate check in a table and have only unique records maintained in the table.
For Example:
ID Name
0000 ABC
0000 ABC
This should return one unique row and update the table.
Can it be done via automations? Looking for the steps here. Thanks.
Aug 20, 2024 11:10 AM
If you have scripting available in your automations, you can delete records from a scripting step. Do you want to merge any fields in the duplicate records, or just delete one entirely?
Aug 20, 2024 02:38 PM
Automation usually created to be triggered by some record (new or changed). But of course, you can insert script step, which will process all table and the trigger might be a schedule for daily or weekly use.
You can do this by scripting Extension (somewhere in Examples you can find a script to remove duplicates), you can use Deduper Extension or you can do it manually, create new linked field (to a new table), copy-paste whole primary field there, and then add data you need by lookups. In duplicated records, all data will be present, so to avoid repeating, you can use rollup ARRAYUNIQUE(values).
It's for one-time action. If you need to do it from time to time, use Extension.
Or you can check it once and then setup automation to check each new record for duplicates.
Aug 21, 2024 11:22 AM
Thank you for the response. I would like to retain one unique record