Data Preparation · Axiom Platform
Data Mapper
Combine any number of CSV or TSV files into a single relational table without writing code. Upload your files, pick a join key for each, and Data Mapper outer-joins them in order — then exports a clean CSV ready for Borehole EDA, CPT Processor, or any external tool.
Upload, map, export
The workflow is linear and non-destructive. Your original files are never modified — Data Mapper only reads them to produce the merged output.
- Upload one or more CSV or TSV files via drag-and-drop or file picker. European number formats (comma decimal, dot thousands) and common separators (comma, semicolon, tab) are auto-detected.
- Each file opens in its own tab so you can inspect columns and spot issues before merging. Column headers are parsed from the first row.
- Select a key column for each file from a dropdown — this is the join key used in the outer merge. Keys do not need to share the same column name across files.
- Data Mapper outer-joins the tables sequentially: file 2 onto file 1, file 3 onto the result, and so on. All rows from all files are retained; unmatched cells are left blank.
Features
Practical details that matter when combining messy real-world CSV exports.
-
Multi-file upload
Add as many CSV or TSV files as you need in one session. Files can come from different sources with different column sets — the merge handles mismatched schemas.
-
Format auto-detection
Separator (comma, semicolon, tab), decimal separator (dot or comma), and thousands separator are detected automatically. No manual format configuration needed.
-
Tabbed file preview
Each uploaded file appears in its own tab with a scrollable table view. Inspect columns and row counts before committing to a merge — catching header or encoding issues early.
-
Configurable key columns
Each file gets its own key column selector. The join key is the common identifier across files — borehole ID, sample reference, location code, or any other linking column.
-
Outer join semantics
All rows from all files are preserved. Where a key exists in one file but not another, the missing cells are left as blank — no data is silently dropped.
-
Merged table preview
The combined table is shown before download, so you can confirm column count and row count match your expectations before exporting.
-
Single-file export
Download the merged result as a single CSV — ready to upload into Borehole EDA, feed into the CPT Processor, or open in any analysis tool.
-
Platform integration
Runs on AxiomBaseLogic with shared auth. The exported CSV can be imported directly into other platform apps — no re-authentication or file re-upload needed.
What you get
The merge API returns the combined table as CSV text plus metadata about the result so you can validate it programmatically before writing to disk.
- merged_csv — the full merged table as a UTF-8 CSV string, with a unified header row and all source columns.
- rows — total row count in the merged output (excluding the header).
- columns — total column count, confirming the union of all source column sets.
REST API
Automate merges in scripts or pipelines — post raw CSV content with key column specs and receive the merged output as JSON.
- POST /data_mapper/api/merge/ JSON body:
{ "tables": [ { "csv_content": "...", "key_column": "id" }, ... ] }. Returnsmerged_csv(UTF-8 CSV string),rows, andcolumns.
Part of the AxiomBaseLogic platform
Data Mapper ships alongside Liquefaction Analysis, Borehole EDA, CPT Processor, Plotter, AGS Parser, and Shallow Foundation — on a single platform with shared auth, shared data, and REST APIs. Subscribe once, access all apps.
Explore other apps
Jump to other AxiomBaseLogic tools and keep your workflow connected across the platform.