You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Support > Troubleshooting > Troubleshooting Guide: Duplicate Header Rows
Troubleshooting Guide: Duplicate Header Rows
print icon

Issue

You are seeing two header rows in your source and output file. This occurs when the headers in your source file do not exactly match those defined in the detamoov File Definition.


What You're Seeing

  • Row 1 (green): Headers automatically added by detamoov to align with the File Definition.
  • Row 2 (yellow): Original headers from your source file.
  • These differences cause what appears to be a duplicate header row, but only Row 1 is used for data mapping.

Mismatch Example:

  • Column C: E/D/T Code (expected) vs. EDT Code (source)
  • Column D: E Base Rate vs. Rate
  • Column E: E Hours vs. Hours
  • Column F: E/D/T Amount vs. Amount
  • Column H: Payroll Pay Date vs. Check Date

Why This Happens

detamoov automatically inserts the correct header row (Row 1) when:

  • Your uploaded file contains header names that do not match the File Definition exactly.
  • This ensures data is aligned correctly with the field mappings but creates a second header row.

How to Resolve

You have two options to fix this and prevent the double header:

Option 1: Update Your Source File

Ensure your source file's header row exactly matches what is defined in the File Definition:

  • Update your CSV file to match expected headers (e.g., "E/D/T Code", "E Base Rate", etc.).

Option 2: Update the File Definition

If you prefer using your existing source headers:

  • Modify the File Definition in detamoov to reflect your current header names.

scroll to top icon