Map inconsistent export columns to target schemas
Match disparate, poorly named export headers to a structured target data schema. Use it when consolidating CSV reports from multiple platforms.
You getMapping Specification and unmapped Raw Columns
Prompt
Act as a data integration specialist. Map the messy raw export column headers below to the provided target data schema.
- Match every raw field to the most appropriate target column based on name, semantic meaning, and data type.
- Identify unmapped fields, split fields (such as full name into first and last), and merged columns.
- Highlight columns that require type casting, unit conversion, or date parsing.
Output format:
1. Mapping Specification: Table with Raw Header, Target Column, Data Type, Transformation Logic
2. Unmapped Raw Columns: List of fields dropped with rationale
3. Missing Target Fields: Target fields that received no source data
Target schema and raw export columns are below:Example output
Paste your target schema definition followed by the source headers or a small CSV sample into ChatGPT, Claude or Gemini. Ask the model for a Python dictionary or JSON mapping config if you are automating the ETL process.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Build three scenarios for revenue and demand forecasts
Generate structured best, base, and worst-case forecast models to prepare for demand swings. Use this during annual planning or runway updates.
Clean inconsistent date formats and text categories
Turn chaotic timestamp formats and varied categorical spellings into unified standards. Use it when mismatched export values break dashboards.
Create an anomaly investigation checklist for analytics teams
Run a disciplined diagnostic process before investigating metric shifts. Use this checklist whenever unexpected data spikes or drops appear in reports.
Diagnose circular loops and friction steps in signup funnels
Map repetitive back-and-forth navigation and error loops within onboarding flows. Use this to pinpoint confusing validation rules and navigation traps.
Differentiate structural null values from missing data
Identify whether null values represent expected business logic or export dropouts. Use it when auditing schema quality or preparing datasets for modeling.
Evaluate past forecast variances to set accurate targets
Analyze past forecast misses to identify systematic over- or under-projection patterns. Use this before locking in next quarter's revenue or operational targets.
- Isolate regional or platform drivers behind KPI drops
- Separate true anomalies from pipeline data errors
- Audit a metric definition guide for ambiguity
- Build standardized KPI definition templates for teams
- Evaluate marketing channel efficiency from campaign performance data
- Evaluate sales rep performance with contextual pipeline data