Overview đź“Š

Once your schema matching task is complete, BDIViz enables you to export the validated mappings for use in data integration pipelines, reporting workflows, or system submissions.

export-matches-gif

How to Export 📤

To begin exporting your results:

  1. Navigate to the Shortcut Panel (top-left corner of the interface).
  2. Click the Export button.
  3. A dialog will appear prompting you to select your preferred export format (CSV or JSON).

Export Formats đź“‹

BDIViz supports two export options designed for different use cases:

The CSV export transforms your original dataset using only the accepted column mappings.

Key Features:

  • Source columns are renamed to their matched target attributes
  • Only accepted matches are included
  • Resulting dataset is ready for immediate analysis or upload

Example Output:

submitter_idgenderraceajcc_pathologic_n
C1234MaleAsianpN1
C5678FemaleWhitepN2
C1111UnknownUnknownpNX

Best For:

  • Data harmonization pipelines
  • Uploads to repositories (e.g., GDC, PDC)
  • Sharing aligned datasets with collaborators

The JSON export provides a structured record of all mapping operations with detailed metadata.

Key Features:

  • Includes column-level mappings and value-level match pairs
  • Records additional metadata like match scores and timestamps
  • Machine-readable for downstream processing or reproducibility

Example Output: 

  [
  {
    "sourceColumn": "Tumor_Focality",
    "targetColumn": "tumor_focality",
    "valueMatches": [
      { "from": "Multifocal", "to": "Multifocal" },
      { "from": "Unifocal", "to": "Unifocal" }
    ]
  },
  {
    "sourceColumn": "Ethnicity",
    "targetColumn": "ethnicity",
    "valueMatches": [
      { "from": "Hispanic or Latino", "to": "hispanic or latino" },
      { "from": "Not reported", "to": "not reported" },
      { "from": "Not-Hispanic or Latino", "to": "not hispanic or latino" }
    ]
  }
]

Best For:

  • Programmatic ingestion and audit trails
  • Reuse in automated systems
  • Reconstructing or refining schema alignment processes

Final Notes đź“ť

  • Ensure all intended mappings are accepted before exporting; rejected and discarded mappings will not be included.
  • Use the Timeline Panel to review decisions prior to export.
  • Both formats can be downloaded directly to your local machine.