This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Alteryx Auto Insights is currently available in the United States, United Kingdom, Australia, and Singapore (English only). Check back here for updates as this availability and language support continues to expand.
@PanPP is correct in that is the right format needed for a date column. But there are some other things to be aware of!
If you have seen this error message, these might be helpful:
Auto Insights Uploader (2) <class 'ayx_python_sdk.core.exceptions.WorkflowRuntimeError'>: Progress: 0.0 %, FAILED, In column [Date], after trying each of the following date format conversion: [['%Y%m%d', '%m%d%Y', '%d%m%Y', '%Y%d%m', '%Y', '%y%m%d', '%m%d%y', '%d%m%y', '%y%d%m']], none of the non-missing values can be converted to date format. We recommend converting the date format to YYYY-MM-DD. Few common examples from the this column are: [[nan]], Step: 0/4, None
Even if it is in that format but the data type is a string, you might not be able to upload the dataset.
Check to make sure all of the dates in your date columns are in the needed format - if you are joining multiple tables together you might get some string values in that are throwing it off. You can tell by looking at the error message at the end where it shows you examples of non date values in the column (bolded in the error message above).
If you have successfully uploaded this dataset before, you should double check the date column to make sure it is not 100% full of nulls or nan values (as indicated in the above error message). Auto Insights cannot ingest a dataset where a date column is completely blank. In order to fix this, you should double check you dataset so that it is not missing any data / ensure you have at least 1 actual date value in the column, or drop that column completely.