Remove duplicate rows within a table or across workspace tables in Airscale V2.
1. Open Dedupe
Click Dedupe below your table.
2. Choose how to find duplicates
Select Other workspace tables to find rows already present in another table, or This table to find repeated values within the current table.
Other workspace tables
Check the current table against other active tables in the same workspace. Choose an available matching key: Website/domain, LinkedIn profile, or Company LinkedIn.Only rows in the current table can be removed; the other tables are checked without being changed. Rows whose key already exists in another table are removed from the current table. Repeated keys within the current table are also deduplicated.A LinkedIn URL is not required when you use Website/domain matching.
This table
Choose a column to find repeated values within the current table. The first row is kept and later duplicates are removed. Empty values are ignored. Values are trimmed before comparison, and exact column matching is case-sensitive.
3. Review before removing duplicates
Review the preview and confirm the removal. Dedupe removes duplicate rows; it does not merge their fields into the retained row.Dedupe checks the current table as a whole, rather than only the rows you have selected or filtered. Make sure the selected matching key is appropriate before confirming.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Airschool","description":"Airscale product guides, integration workflows, MCP documentation, and public API reference.","colors":{"primary":"#4079FF","light":"#4079FF","dark":"#6F9BFF"},"logo":{"light":"https://mintcdn.com/airscale/T4fnFCkEZYFIfzlE/logo/light.svg?fit=max\u0026auto=format\u0026n=T4fnFCkEZYFIfzlE\u0026q=85\u0026s=77cac19c9833b1b4b3e8cc1a21fe7c04","dark":"https://mintcdn.com/airscale/T4fnFCkEZYFIfzlE/logo/dark.svg?fit=max\u0026auto=format\u0026n=T4fnFCkEZYFIfzlE\u0026q=85\u0026s=3fae4b34efca46e05ac0dcb7d1febe81","href":"/"},"favicon":"https://mintcdn.com/airscale/6bM8EcCHTBu_Tci4/favicon.svg?fit=max\u0026auto=format\u0026n=6bM8EcCHTBu_Tci4\u0026q=85\u0026s=0f5e216ce2f6809f53f85f184935b9d6","api":{"openapi":"openapi.json","playground":{"display":"simple"},"examples":{"defaults":"required","languages":["curl","node","python"],"prefill":true,"autogenerate":true}},"appearance":{"default":"light"},"navbar":{"links":[{"href":"https://airscale.io/","label":"Back to website"}],"primary":{"type":"button","label":"Open Dashboard","href":"https://app.airscale.io/dashboard"}},"search":{"prompt":"Search Airschool..."},"seo":{"metatags":{"robots":"index, follow","canonical":"https://docs.airscale.io"},"indexing":"navigable"},"fonts":{"family":"Poppins"},"icons":{"library":"lucide"},"styling":{"eyebrows":"breadcrumbs","codeblocks":{"theme":{"light":"github-light","dark":"github-dark"}},"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"airscale","hasAudioNarration":false,"actualSubdomain":"airscale","customDomains":["docs.airscale.io"],"gitSource":{"type":"github","owner":"vicescale","repo":"airscale-docs","deployBranch":"docs/production-release-20260923","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6afc87a93f62856de487d60e","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"default","tag":"API Reference","count":85},{"language":"default","tag":"Documentation","count":48},{"language":"default","tag":"Intent signals","count":31},{"language":"default","tag":"Enrichments","count":26},{"language":"default","tag":"Table API","count":15},{"language":"default","tag":"Post engagements","count":11},{"language":"default","tag":"Miscellaneous","count":10},{"language":"default","tag":"Job changes","count":10},{"language":"default","tag":"New hires","count":10},{"language":"default","tag":"Build lists","count":10}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[{"filePath":"custom.css","content":"#navbar img.nav-logo:is([alt=\"light logo\"],[alt=\"dark logo\"]){height:38px!important}#navbar a[href=\"https://app.airscale.io/dashboard\"]{background-color:#111827!important;border-color:#111827!important;border-radius:10px!important;color:#FFFFFF!important}#navbar a[href=\"https://app.airscale.io/dashboard\"]:hover{background-color:#000000!important;border-color:#000000!important}#navbar a[href=\"https://app.airscale.io/dashboard\"] :is(span,svg){color:inherit!important}#navbar a[href=\"https://app.airscale.io/dashboard\"]>span.absolute.inset-0{background-color:inherit!important;border-radius:10px!important}html.dark #navbar a[href=\"https://app.airscale.io/dashboard\"]{background-color:#FFFFFF!important;border-color:#FFFFFF!important;color:#111827!important}html.dark #navbar a[href=\"https://app.airscale.io/dashboard\"]:hover{background-color:#E5E7EB!important;border-color:#E5E7EB!important}#sidebar button.sidebar-group-header[data-airscale-collapsible=\"true\"]{appearance:none;background:transparent;border:0;cursor:pointer;text-align:left;width:100%}#sidebar button.sidebar-group-header[data-airscale-collapsible=\"true\"]::after{content:\"›\";font-size:1.25rem;line-height:1;margin-left:auto;transition:transform 150ms ease}#sidebar button.sidebar-group-header[data-airscale-collapsible=\"true\"][aria-expanded=\"true\"]::after{transform:rotate(90deg)}"},{"filePath":"airschool.css","content":".airschool{--school-text: #121419;--school-muted: #697289;--school-border: #e2e7ee;--school-surface: #fff;--school-subtle: #f9fafb;color:var(--school-text);background:var(--school-surface) url('/images/airschool/grid.svg') center top / cover;padding:80px 0;font-family:Poppins, sans-serif}.airschool *{box-sizing:border-box}.airschool :is(h1,h2,h3,p){margin:0}.airschool a{color:inherit;text-decoration:none}.airschool a.link{border-bottom-color:var(--school-border)!important}.airschool a.link:hover{border-bottom-color:#aab6cb!important}.airschool-content{width:100%;max-width:1200px;margin:0 auto;padding:0 32px;display:grid;gap:80px}.airschool-hero{display:grid;justify-items:center;gap:40px;text-align:center}.airschool-intro{max-width:768px;display:grid;justify-items:center;gap:20px}.airschool .airschool-badge{border:1px solid var(--school-border);border-radius:99px;padding:9px 16px;background:var(--school-surface);font-size:12px;line-height:16px;font-weight:500}.airschool h1{font-size:48px;line-height:56px;font-weight:600;letter-spacing:-1.8px}.airschool .airschool-description{max-width:600px;font-size:16px;line-height:28px;color:#333842}.airschool-search-area{width:100%;max-width:680px;display:grid;justify-items:center;gap:24px}.airschool-search{width:100%;max-width:550px;min-height:56px;padding:12px 16px;display:flex;align-items:center;gap:12px;border:1px solid var(--school-border);border-radius:16px;background:var(--school-surface);color:var(--school-muted);text-align:left;font:inherit;font-size:14px;cursor:pointer;box-shadow:0 3px 8px -5px #0003}.airschool-search>svg{flex:none}.airschool-shortcut-keys{margin-left:auto;display:flex;gap:4px}.airschool kbd{display:grid;place-items:center;width:28px;height:28px;border:1px solid var(--school-border);border-radius:8px;background:var(--school-subtle);font:inherit;font-size:12px}.airschool-shortcuts{display:flex;flex-wrap:wrap;gap:8px;align-items:center;justify-content:center;font-size:12px;line-height:18px;color:var(--school-muted)}.airschool-shortcuts a{padding:5px 10px;background:var(--school-subtle);border:1px solid var(--school-border);border-radius:8px;font-weight:500}.airschool-section{display:grid;gap:32px}.airschool h2{font-size:20px;line-height:28px;font-weight:400;letter-spacing:-.5px}.airschool-categories{display:grid;grid-template-columns:repeat(3, minmax(0, 1fr));gap:20px}.airschool-card{display:flex;flex-direction:column;gap:20px;padding:12px;border:1px solid var(--school-border);border-radius:36px;background:var(--school-surface);transition:border-color 150ms ease, box-shadow 150ms ease}.airschool-card img{display:block;width:100%;height:auto;aspect-ratio:2 / 1;object-fit:cover;border-radius:24px;margin:0}.airschool-card-content{flex:1;display:flex;flex-direction:column;justify-content:space-between;gap:16px;padding:0 16px 16px}.airschool h3{font-size:16px;line-height:24px;font-weight:400;letter-spacing:-.4px}.airschool-card p,.airschool-support-card p{margin-top:6px;font-size:12px;line-height:18px;color:var(--school-muted)}.airschool-link{font-size:14px;line-height:20px;color:var(--school-muted);font-weight:500}.airschool-link>span{display:inline-block;margin-left:3px}.airschool-support-grid{display:grid;grid-template-columns:repeat(2, minmax(0, 1fr));gap:20px}.airschool-support-card{display:flex;align-items:center;gap:20px;padding:28px;border:1px solid var(--school-border);border-radius:32px;background:var(--school-surface);transition:border-color 150ms ease, box-shadow 150ms ease}.airschool-support-icon{display:grid;place-items:center;flex:none;width:50px;height:50px;border-radius:50%;background:var(--school-subtle);color:var(--school-muted)}.airschool-support-copy{flex:1}.airschool-support-card>.airschool-link{flex:none}.airschool :is(.airschool-card,.airschool-support-card,.airschool-search,.airschool-shortcuts a):hover{border-color:#aab6cb;box-shadow:0 4px 16px -10px #33415555}.airschool :is(a,button):focus-visible{outline:3px solid #4079ff;outline-offset:4px}html.dark .airschool{--school-text: #f4f5f7;--school-muted: #aeb7c8;--school-border: #303640;--school-surface: #111316;--school-subtle: #1b1e24;background-image:none}html.dark .airschool .airschool-description{color:#c4cbd6}html.dark .airschool-card img{filter:brightness(.88)}@media (max-width: 1000px){.airschool-support-card{flex-wrap:wrap;gap:16px;padding:24px}.airschool-support-card>.airschool-link{width:100%;padding-left:66px}}@media (max-width: 700px){.airschool{padding:48px 0}.airschool-content{padding:0 20px;gap:48px}.airschool h1{font-size:36px;line-height:44px;letter-spacing:-1.2px}.airschool .airschool-description{font-size:15px;line-height:26px}.airschool-hero{gap:28px}.airschool-categories,.airschool-support-grid{grid-template-columns:minmax(0, 1fr)}.airschool-section{gap:24px}.airschool-shortcut-keys{display:none}.airschool-shortcuts>span{width:100%}.airschool-card{border-radius:28px}.airschool-card-content{padding:0 12px 12px}}@media (prefers-reduced-motion: reduce){.airschool :is(.airschool-card,.airschool-support-card){transition:none}}"}]}
{"page":{"pagePath":"docs/deduplicate-leads-tables","slug":"/docs/deduplicate-leads-tables","pageMetadata":{"title":"Deduplicate leads between tables","description":"Remove duplicate rows within a table or across workspace tables in Airscale V2.","canonical":"https://docs.airscale.io/docs/deduplicate-leads-tables","href":"/docs/deduplicate-leads-tables"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Remove duplicate rows within a table or across workspace tables in Airscale V2.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={p:`p`,strong:`strong`,..._provideComponents(),...props.components},{Heading,OptimizedImage}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`1-open-dedupe`,children:`1. Open Dedupe`}),`\n`,_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Dedupe`}),` below your table.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/airscale/Lmx5Gx6xoN8r9ouT/images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png?fit=max\u0026auto=format\u0026n=Lmx5Gx6xoN8r9ouT\u0026q=85\u0026s=56ed4cd37e4a1139d6799fefb4ba5fe7`,alt:`Airscale V2 table with the Dedupe button below the rows — red arrow highlights the control to use`,width:`700`,\"data-og-width\":`2860`,\"data-og-height\":`681`,\"data-path\":`images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/airscale/Lmx5Gx6xoN8r9ouT/images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png?w=280\u0026fit=max\u0026auto=format\u0026n=Lmx5Gx6xoN8r9ouT\u0026q=85\u0026s=1d351128e8fb5734893ec93064cf57a2 280w, https://mintcdn.com/airscale/Lmx5Gx6xoN8r9ouT/images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png?w=560\u0026fit=max\u0026auto=format\u0026n=Lmx5Gx6xoN8r9ouT\u0026q=85\u0026s=820614c88e5d6ccd0248dd01b09e0f98 560w, https://mintcdn.com/airscale/Lmx5Gx6xoN8r9ouT/images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png?w=840\u0026fit=max\u0026auto=format\u0026n=Lmx5Gx6xoN8r9ouT\u0026q=85\u0026s=912cab9a4d4f186b6cfe8be407b57d7e 840w, https://mintcdn.com/airscale/Lmx5Gx6xoN8r9ouT/images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png?w=1100\u0026fit=max\u0026auto=format\u0026n=Lmx5Gx6xoN8r9ouT\u0026q=85\u0026s=ec9941dc8ce07132c46380d919d31b94 1100w, https://mintcdn.com/airscale/Lmx5Gx6xoN8r9ouT/images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png?w=1650\u0026fit=max\u0026auto=format\u0026n=Lmx5Gx6xoN8r9ouT\u0026q=85\u0026s=2c20163ee1e39fa2f73c6b30358f19c1 1650w, https://mintcdn.com/airscale/Lmx5Gx6xoN8r9ouT/images/v2/arrows/table-toolbar-b2a8bda2-retina-wide.png?w=2500\u0026fit=max\u0026auto=format\u0026n=Lmx5Gx6xoN8r9ouT\u0026q=85\u0026s=e6640d15881b6207735428aa01ffed81 2500w`}),`\n`,_jsx(Heading,{level:`2`,id:`2-choose-how-to-find-duplicates`,children:`2. Choose how to find duplicates`}),`\n`,_jsxs(_components.p,{children:[`Select `,_jsx(_components.strong,{children:`Other workspace tables`}),` to find rows already present in another table, or `,_jsx(_components.strong,{children:`This table`}),` to find repeated values within the current table.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/airscale/tA5uV_If3gYdGEom/images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png?fit=max\u0026auto=format\u0026n=tA5uV_If3gYdGEom\u0026q=85\u0026s=cddabeb9881dd14e7355420e22295271`,alt:`V2 dedupe dialog with workspace tables and LinkedIn profile URL matching selected — red arrow highlights the control to use`,width:`700`,\"data-og-width\":`2860`,\"data-og-height\":`1240`,\"data-path\":`images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/airscale/tA5uV_If3gYdGEom/images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png?w=280\u0026fit=max\u0026auto=format\u0026n=tA5uV_If3gYdGEom\u0026q=85\u0026s=81325eb1b702be3fdba6e3f54317718a 280w, https://mintcdn.com/airscale/tA5uV_If3gYdGEom/images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png?w=560\u0026fit=max\u0026auto=format\u0026n=tA5uV_If3gYdGEom\u0026q=85\u0026s=07db0ea3c5e35936a4d5db5ea0a9e26a 560w, https://mintcdn.com/airscale/tA5uV_If3gYdGEom/images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png?w=840\u0026fit=max\u0026auto=format\u0026n=tA5uV_If3gYdGEom\u0026q=85\u0026s=a08d38bded96b3e604bf058071bb2ee9 840w, https://mintcdn.com/airscale/tA5uV_If3gYdGEom/images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png?w=1100\u0026fit=max\u0026auto=format\u0026n=tA5uV_If3gYdGEom\u0026q=85\u0026s=83c4c7f7b047714643fcc1af8f2297a0 1100w, https://mintcdn.com/airscale/tA5uV_If3gYdGEom/images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png?w=1650\u0026fit=max\u0026auto=format\u0026n=tA5uV_If3gYdGEom\u0026q=85\u0026s=a93169103a279c2352f115397baa29c1 1650w, https://mintcdn.com/airscale/tA5uV_If3gYdGEom/images/v2/arrows/dedupe-dialog-790a3aa7-retina-wide.png?w=2500\u0026fit=max\u0026auto=format\u0026n=tA5uV_If3gYdGEom\u0026q=85\u0026s=edd9d34ef37a09db4444d28d1a34c503 2500w`}),`\n`,_jsx(Heading,{level:`3`,id:`other-workspace-tables`,children:`Other workspace tables`}),`\n`,_jsxs(_components.p,{children:[`Check the current table against other active tables in the same workspace. Choose an available matching key: `,_jsx(_components.strong,{children:`Website/domain`}),`, `,_jsx(_components.strong,{children:`LinkedIn profile`}),`, or `,_jsx(_components.strong,{children:`Company LinkedIn`}),`.`]}),`\n`,_jsx(_components.p,{children:`Only rows in the current table can be removed; the other tables are checked without being changed. Rows whose key already exists in another table are removed from the current table. Repeated keys within the current table are also deduplicated.`}),`\n`,_jsx(_components.p,{children:`A LinkedIn URL is not required when you use Website/domain matching.`}),`\n`,_jsx(Heading,{level:`3`,id:`this-table`,children:`This table`}),`\n`,_jsx(_components.p,{children:`Choose a column to find repeated values within the current table. The first row is kept and later duplicates are removed. Empty values are ignored. Values are trimmed before comparison, and exact column matching is case-sensitive.`}),`\n`,_jsx(Heading,{level:`2`,id:`3-review-before-removing-duplicates`,children:`3. Review before removing duplicates`}),`\n`,_jsx(_components.p,{children:`Review the preview and confirm the removal. Dedupe removes duplicate rows; it does not merge their fields into the retained row.`}),`\n`,_jsx(_components.p,{children:`Dedupe checks the current table as a whole, rather than only the rows you have selected or filtered. Make sure the selected matching key is appropriate before confirming.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"codeStyling":{"theme":{"light":"github-light","dark":"github-dark"}},"config":{},"pageMetadata":{"title":"Deduplicate leads between tables","description":"Remove duplicate rows within a table or across workspace tables in Airscale V2.","canonical":"https://docs.airscale.io/docs/deduplicate-leads-tables","href":"/docs/deduplicate-leads-tables"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"1. Open Dedupe","slug":"1-open-dedupe","depth":2,"children":[]},{"title":"2. Choose how to find duplicates","slug":"2-choose-how-to-find-duplicates","depth":2,"children":[{"title":"Other workspace tables","slug":"other-workspace-tables","depth":3,"children":[]},{"title":"This table","slug":"this-table","depth":3,"children":[]}]},{"title":"3. Review before removing duplicates","slug":"3-review-before-removing-duplicates","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/airscale/9fa3b93ce50bf4a8/custom.js"],"subdomain":"airscale","siteName":"Airschool","title":"Deduplicate leads between tables - Airschool","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-11-04T18:04:44.389Z","originalFileLocation":"docs/deduplicate-leads-tables.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Remove duplicate rows within a table or across workspace tables in Airscale V2.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Airschool\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003cmeta data-mint-head name=\"robots\" content=\"index, follow\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Deduplicate leads between tables - Airschool\">\u003cmeta data-mint-head property=\"og:description\" content=\"Remove duplicate rows within a table or across workspace tables in Airscale V2.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Airschool\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.airscale.io/docs/deduplicate-leads-tables\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://airscale.mintlify.site/_mintlify/api/og/v2?division=Utilities\u0026amp;title=Deduplicate+leads+between+tables\u0026amp;description=Remove+duplicate+rows+within+a+table+or+across+workspace+tables+in+Airscale+V2.\u0026amp;theme=49995a472942850add47fde8\u0026amp;signature=623d0331bf0b5d44e6e65ec223dde30c0f47b882c1e7eafb90fae6c7f4ce86f0\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Deduplicate leads between tables - Airschool\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Remove duplicate rows within a table or across workspace tables in Airscale V2.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://airscale.mintlify.site/_mintlify/api/og/v2?division=Utilities\u0026amp;title=Deduplicate+leads+between+tables\u0026amp;description=Remove+duplicate+rows+within+a+table+or+across+workspace+tables+in+Airscale+V2.\u0026amp;theme=49995a472942850add47fde8\u0026amp;signature=623d0331bf0b5d44e6e65ec223dde30c0f47b882c1e7eafb90fae6c7f4ce86f0\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/airscale/iIlUU29U7SNYsr3_/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Airschool\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#4079FF\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.airscale.io/docs/deduplicate-leads-tables\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/deduplicate-leads-tables.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.airscale.io/#organization\",\"name\":\"Airschool\",\"url\":\"https://docs.airscale.io\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/airscale/T4fnFCkEZYFIfzlE/logo/light.svg?fit=max\u0026auto=format\u0026n=T4fnFCkEZYFIfzlE\u0026q=85\u0026s=77cac19c9833b1b4b3e8cc1a21fe7c04\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.airscale.io#website\",\"name\":\"Airschool\",\"url\":\"https://docs.airscale.io\",\"publisher\":{\"@id\":\"https://docs.airscale.io/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.airscale.io/docs/deduplicate-leads-tables#webpage\",\"url\":\"https://docs.airscale.io/docs/deduplicate-leads-tables\",\"name\":\"Deduplicate leads between tables\",\"description\":\"Remove duplicate rows within a table or across workspace tables in Airscale V2.\",\"dateModified\":\"2026-11-04T18:04:44.389Z\",\"isPartOf\":{\"@id\":\"https://docs.airscale.io#website\"},\"breadcrumb\":{\"@id\":\"https://docs.airscale.io/docs/deduplicate-leads-tables#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.airscale.io/docs/deduplicate-leads-tables#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Utilities\",\"item\":\"https://docs.airscale.io/docs/users-workspaces\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deduplicate leads between tables\",\"item\":\"https://docs.airscale.io/docs/deduplicate-leads-tables\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.airscale.io/docs/deduplicate-leads-tables#article\",\"headline\":\"Deduplicate leads between tables\",\"name\":\"Deduplicate leads between tables\",\"description\":\"Remove duplicate rows within a table or across workspace tables in Airscale V2.\",\"url\":\"https://docs.airscale.io/docs/deduplicate-leads-tables\",\"mainEntityOfPage\":{\"@id\":\"https://docs.airscale.io/docs/deduplicate-leads-tables#webpage\"},\"dateModified\":\"2026-11-04T18:04:44.389Z\",\"publisher\":{\"@id\":\"https://docs.airscale.io/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.airscale.io#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Airschool\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Airschool\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/docs/deduplicate-leads-tables.md","siteName":"Airschool","nav":{"global":null,"tabs":[{"tab":"Home","pages":[{"title":"Home","href":""}]},{"tab":"Documentation","groups":[{"group":"Build lists","pages":[{"title":"Scrape a Sales Navigator search","href":"/docs/sales-navigator"},{"title":"Extract post likers/commenters","href":"/docs/likers-commenters"},{"title":"Single Search","href":"/docs/single-search"},{"title":"Leads finder","href":"/docs/leads-finder"},{"title":"Find People","href":"/docs/find-people"},{"title":"Find Companies","href":"/docs/find-companies"},{"title":"Find Companies (Linkedin)","href":"/docs/find-companies-linkedin"},{"title":"Find local businesses with Google Maps","href":"/docs/google-maps"},{"title":"Find companies hiring for specific positions","href":"/docs/companies-hiring"},{"title":"Import a file as a CSV","href":"/docs/import-csv"}]},{"group":"Enrichments","pages":[{"title":"Find phone numbers","href":"/docs/phone-numbers"},{"title":"Find professional emails","href":"/docs/professional-emails"},{"title":"Find personal emails","href":"/docs/personal-emails"},{"title":"Verify if an email is deliverable","href":"/docs/verify-email"},{"title":"Enrich people profile from LinkedIn","href":"/docs/enrich-people-linkedin"},{"title":"Enrich company profile from LinkedIn","href":"/docs/enrich-company-linkedin"},{"title":"Fetch company insights","href":"/docs/fetch-company-insights"},{"title":"Find current job openings on LinkedIn","href":"/docs/job-openings-linkedin"},{"title":"Find the latest posts of a company / person","href":"/docs/linkedin-posts-scraper"},{"title":"Find LinkedIn profile data from a phone number","href":"/docs/reverse-phone"},{"title":"Find LinkedIn profile data from an email","href":"/docs/reverse-email"},{"title":"AI custom prompts","href":"/docs/ai-custom-prompts"},{"title":"AI agent (AirSearch)","href":"/docs/ai-agent-airsearch"},{"title":"Create custom Google searches","href":"/docs/google-searches"},{"title":"Find a LinkedIn profile URL","href":"/docs/linkedin-profile-url"},{"title":"Find a LinkedIn company URL","href":"/docs/linkedin-company-url"},{"title":"Find a Linkedin company URL from a domain","href":"/docs/linkedin-company-url-from-a-domain"},{"title":"Fetch a company's Meta ads","href":"/docs/meta-ads"},{"title":"Fetch a company's Google ads","href":"/docs/google-ads"},{"title":"Find a company domain","href":"/docs/company-domain"},{"title":"Find company technologies","href":"/docs/company-technologies"},{"title":"Find company funding data","href":"/docs/funding-data"},{"title":"Extract website content with Zenrows","href":"/docs/website-content"},{"title":"Fetch business intent topics","href":"/docs/fetch-business-intent-topics"},{"title":"Find company website traffic data","href":"/docs/website-traffic"},{"title":"Lookup contacts in Hubspot","href":"/docs/lookup-hubspot"}]},{"group":"Export","pages":[{"title":"Export your data as CSV","href":"/docs/export-csv"},{"title":"Transfer your data to another table","href":"/docs/transfer-another-table"},{"title":"Export your leads to HubSpot","href":"/docs/export-hubspot"},{"title":"Export your leads to Instantly","href":"/docs/export-instantly"},{"title":"Export your leads to Smartlead","href":"/docs/export-smartlead"},{"title":"Export your leads to Lemlist","href":"/docs/export-lemlist"}]},{"group":"CRM integrations","pages":[{"title":"Import contacts from Hubspot","href":"/docs/import-hubspot"},{"title":"Airscale for HubSpot app","href":"/docs/hubspot-app"}]},{"group":"Utilities","pages":[{"title":"Add users \u0026 switch workspaces","description":"Invite new users to your workspace and seamlessly switch between different workspaces based on your needs","href":"/docs/users-workspaces"},{"title":"Deduplicate leads between tables","href":"/docs/deduplicate-leads-tables"},{"title":"Filter tables","description":"Apply filters to your tables to quickly find and analyze the data that matters most","href":"/docs/filer-tables"},{"title":"Transfer column content","href":"/docs/transfer-content"}]}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/api-reference/api-overview"}]},{"tab":"MCP \u0026 Agents","pages":[{"title":"MCP \u0026 Agents","href":"/mcp/how-to-use-the-airscale-mcp"}]},{"tab":"CLI","pages":[{"title":"CLI","href":"/cli/overview"}]},{"tab":"Use cases","pages":[{"title":"Use cases","href":"/usecases/quick-beginner-guide"}]}]},"basePath":"","title":"Deduplicate leads between tables - Airschool","deploymentId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","buildId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","dynamics":["a74be98ba7"],"chunks":["zoom-image-lightbox-BQ4tbj_9.js","lightbox-handle-r17bVUz3.js"]}