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.
I have multiple Excel files (that have the same schema) which I am attempting to bring into alteryx using the Input Data tool. The input works as one would expect, but one field is a date field, and it imports the wrong date. I am not sure how to describe this, so pictures are below:
This is the table I want to bring into alteryx. I have one file like this for each month for 8 years. Note that the Date column is a link from another worksheet
When I bring this into alteryx I get this:
I examined the source link from the Excel file and found that the 'Date' was really text, with each date having a leading space.
Please note that except for the 'Date', these records have different values. I mention this in case someone suggests that I just import the table below (which by the way imports correctly).
I am hoping that there is a way to solve this problem without having to open each of the Excel files.
If anyone has an answer, I would greatly appreciate it. Peace
Not sure why this works, but it seems to --- in the Input Data tool, for File Format select 'Microsoft Excel Legacy'. When I do this, it brings in the original text string, which you can then convert to a date: