> ## Documentation Index
> Fetch the complete documentation index at: https://docs.airscale.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Deduplicate leads between tables

> Identify and merge duplicate leads between your tables to keep your database clean and accurate

## 0. Prerequisites

* You must have tables with contacts or companies
* Each lead (contact or company) must have a LinkedIn profile URL to be identified, as this is the unique identifier that is used

## 1. Click on "Dedupe" at the bottom left of your table

Launch this workflow and all rows in the current table will be checked for potential duplicates across all your other existing tables. If duplicates are found, the corresponding row in the table will be deleted

<img src="https://mintcdn.com/airscale/rvPtpUgeIpGkJ8m7/images/docs/By5M1bxsBoCkqXwsRHIOsXHE.png?fit=max&auto=format&n=rvPtpUgeIpGkJ8m7&q=85&s=8071ba391df2da3df98f52e61f08e32d" alt="Deduplicate leads between tables — 1. Click on &#x22;Dedupe&#x22; at the bottom left of your table" width="3004" height="1450" data-path="images/docs/By5M1bxsBoCkqXwsRHIOsXHE.png" />

<img src="https://mintcdn.com/airscale/aXid-NqBkne9U7iH/images/docs/aAqwhxs8GBfExpkStDKoRJlG2yc.png?fit=max&auto=format&n=aXid-NqBkne9U7iH&q=85&s=4429d0c3eaa3a8f215c12a8218501521" alt="Deduplicate leads between tables — 1. Click on &#x22;Dedupe&#x22; at the bottom left of your table" width="3006" height="1458" data-path="images/docs/aAqwhxs8GBfExpkStDKoRJlG2yc.png" />

It may take a few minutes to run entirely if the current table is large. Once the workflow is launched, you can safely close the pop-up as the workflow will be running in the background

**Note**: the dedupe workflow runs within the same object type, contacts with contacts, and companies with companies only


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.