Duplicate records can be a nightmare to deal with, polluting the data and hard to detect. Acho makes duplicate detection and elimination easy with the Deduplicate action. Select the combination of key fields to summarize duplicate by (try your Primary Keys!), and then select to show duplicate or simply eliminate them. Show Duplicate action will filter the table to only records that are non-distinct per the duplicate check keys, this is often good for data exploration. Once checked, if it is determined that the duplicates are invalid and should be eliminated, the Eliminate Duplicates action will keep only one unique record per key and eliminate the excess.
Last modified 1yr ago