Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Auto Insights Knowledge Base

Definitive answers from Auto Insights experts

My time series data is in different formats

nathan_love
Alteryx
Alteryx
Created

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.pngimage.png

After:
image.pngimage.png