CSV Anti-Join Finder

Store Positioning

Store title: CSV Anti-Join Finder

Short description: Find rows in one CSV that do not have matching keys in another CSV, with support for composite keys, normalization rules, duplicate diagnostics, and left-only/right-only export reports.

SEO title: CSV Anti-Join Finder — data QA, validation, and cleanup utility

SEO description: Find rows in one CSV that do not have matching keys in another CSV, with support for composite keys, normalization rules, duplicate diagnostics, and left-only/right-only export reports. Use it to validate rows, schemas, duplicates, field quality, and delivery-readiness before handing data to clients or automations.

Categories: DEVELOPER_TOOLS

Keywords: csv, anti, join, finder, csv qa, data/schema qa utility

Pay-Per-Event Pricing

This actor uses pay-per-event pricing. Event prices include Apify platform usage; users are not expected to pay a separate platform-usage pass-through charge for the configured pricing model.

• Tier: U2 — Data/schema QA utility
• Primary event: row-checked at $0.00390 base
• Default max charge: $5.00
• Store discounts: FREE/BRONZE base, SILVER discounted, GOLD deepest approved discount

Event set:

• actor-start: base $0.00500, GOLD $0.00400. CSV Anti Join Finder: charged when actor start is completed. The price includes Apify platform usage; no separate usage pass-through is intended.
• row-checked: base $0.00390, GOLD $0.00312. CSV Anti Join Finder: charged when row checked is completed. The price includes Apify platform usage; no separate usage pass-through is intended.
• issue-detected: base $0.00372, GOLD $0.00298. CSV Anti Join Finder: charged when issue detected is completed. The price includes Apify platform usage; no separate usage pass-through is intended.
• qa-report-generated: base $0.05000, GOLD $0.04000. CSV Anti Join Finder: charged when qa report generated is completed. The price includes Apify platform usage; no separate usage pass-through is intended.

Public Task Concepts

• Audit CSV Anti-Join controls on a capped public sample
• Find high-priority CSV Anti-Join issues before release
• Validate CSV Anti-Join evidence from supplied pages
• Prioritize CSV Anti-Join fixes with severity and proof
• Export CSV Anti-Join QA rows for client review

Finds left-only and right-only CSV rows by normalized single or composite keys, emitting source row indexes, key hashes, duplicate diagnostics, and reconciliation recommendations.

Inputs

• leftCsvUrl
• rightCsvUrl
• leftCsvText
• rightCsvText
• leftKeyColumns
• rightKeyColumns
• antiJoinMode
• normalizationRules
• includeSourceRows
• includeMatchedSummary
• maxRows
• sampleLimit
• timeoutMs
• maxChargeUsd

Public source provenance

The starter input uses https://raw.githubusercontent.com/datasets/country-list/master/data.csv compared with https://raw.githubusercontent.com/datasets/country-codes/master/data/country-codes.csv using ISO alpha-2 codes. The checked-in bounded snapshot keeps exact runs deterministic and avoids sending credentials or private data. Live URL inputs remain available when a current network check is required.

Outputs

Dataset fields: side, rowIndex, keyColumns, keyValue, normalizedKey, keyHash, antiJoinReason, matchCountOtherSide, duplicateCountSameSide, sourceRow, warning, recommendation.

Reports: csv-anti-join-report.md, left-only-rows.csv, right-only-rows.csv, anti-join-match-summary.json, key-normalization-log.csv.

Use small capped runs first; live network checks should stay bounded and avoid secrets in inputs.

Live and local execution use the same pay-per-event billing guard: the actor-start event is accepted before analysis, each paid row is charged before dataset output, reports are charged before key-value-store output, and maxChargeUsd stops gracefully without leaking unpaid artifacts.