Updated on
Mar 27, 2024
The Date column is a unique date-key in the database and must be singular. The Date column is needed if you want to use update logic that utilizes date-key (i.e. Incremental update logic).
To optimize data processing and ensure alignment with our internal systems, Improvado platform prioritizes columns named Date for identifying unique date-key. To ensure clarity and avoid any unintentional use of existing Date columns, we recommend renaming them to a more specific name within your spreadsheet context.
If your files have empty values in the Date key column, you’ll need to set up a Skip rule for this column. Otherwise, you’ll receive an error during extraction.
We offer a wide range of date formats for the Date column, allowing you to choose the one that best matches your existing setup.
You can also see the full list of supported date formats: {%dropdown-button name="destination" %}
{%dropdown-body name="destination" %}
{%dropdown-end%}
Note: The date format you select from the dropdown indicates the date format in that column of your spreadsheet and helps us correctly parse dates in that column. But it is not the date format that will be stored in Improvado.
If the date format in your Flat Data files is missing from the list, you can create a new request using the Improvado Service Desk.
Our system automatically adds the following default columns:
Please avoid importing columns with these names to prevent data conflicts.
Improvado team is always happy to help with any other questions you might have! Send us an email.
Contact your Customer Success Manager or raise a request in Improvado Service Desk.