InvestJoin — link records across CSV files
Stitch scattered CSVs together by person, account, and phone for investigations
- Problem
- Fraud and investigation analysts juggle a dozen separate CSVs — customers, accounts, phones, transactions, addresses, devices. Each makes sense alone, but connecting related records across files and finding the same entity still means hand-written SQL and Excel cross-checks that are slow and hard to reproduce.
- Solution
- A local-first linking workbench: upload multiple CSVs, auto-normalize and fuzzy-match identity fields (names, phones, addresses), get an interactive relationship view, drill from any record into all related rows, and export a sourced link report. All computation stays on the machine.
- Users
- Fraud analysts, compliance investigators, independent data consultants, auditors doing due diligence
- MVP
- CSV import with field mapping; normalization and fuzzy matching on common identifiers; relationship graph with drill-down; one-click sourced link report with row references; fully local processing
- Revenue
- One-time desktop license; team plan per analyst seat; private deployment for enterprise
- Why now
- Better matching tech lowers the barrier while this work is dominated by expensive forensic suites; local-first answers growing data-compliance concerns