My time series data is in different formats

[nathan_love]

Issue

I have time series data, but it is in different formats

Cause

There is no standard approach to date formatting, so this will vary depending on the data sources you have used.

Resolution

This can be resolved using the DateTime tool in Alteryx. Auto Insights requires it to be in YYYY-MM-DD format. You can use Multiple DateTime tools, if you have multiple date fields that need to be ingested
This tool will create a new field in your data, so don’t forget to deselect the original field before uploading.

Before:

image.png

After:
image.png