Wrong data format

WRONG DATA FORMAT

Explanation

If you’ve created a custom source successfully, but the extracted data shows an unexpected format (e.g., incorrect date display), it’s likely due to a mismatch in the data type. For instance, if the data type is set to string instead of date, this can cause the date values to appear incorrectly.

In the screenshot example, the data type is incorrectly set to string, resulting in the issue. When you encounter this type of discrepancy, follow these steps for a quick check and a potentially simple solution:

How to Correct the Data Type

  • Go to the Sources tab and select the affected source.
  • Within the Source Menu, navigate to the Schema section.
  • Update the data type for the relevant field(s) to date.
  • Perform a manual data load to apply the changes.

Next Steps if the Issue Persists

If the source continues to display incorrect values after updating the data type:

Review any applied transformations to ensure they are not altering the data format.

Contact the support team for further assistance if needed.

By following these steps, you can ensure the data is extracted in the correct format and resolve common type-related discrepancies.

1 Like