880 views

Troubleshooting Import – Missing data as a result of a wrong date format

 

Problem

This issue is related to data import and transform. Data is successfully imported into a staging table, but when the data is transformed to a target table, some or all date/time values are missing.

 

Symptoms


  • Import says complete, but not all data is present
  • Data discrepancy after import
  • Import set has error
 
Cause

When creating the transform map for the new import set, you are adding a field map for a date type field. A field map has a date format attribute you must populate with the format of the date values. The date format is either wrong or was not set, causing the system to use the default date format. In either case, the date format used is different than what the incoming date values are using.

 

Resolution

To solve the issue, set the date format on the field map to match the format of the data. 

Article Information

Last Updated:2017-10-24 15:14:04
Published:2014-05-09