Detection Methods:

• Exact Match: Identical values
• Case Insensitive: Ignore letter case
• Whitespace Trimmed: Ignore spaces
• Multi-column: Combined key matching

Column Selection:

• Select all columns for full record duplicates
• Select key columns for business logic duplicates
• ID columns often indicate true duplicates

Results:

• Groups show all rows with same key
• First occurrence marked as "Original"
• Cleaned data keeps only originals