Input interpretation error with .xlsx file

Joma

Hi all,

i am having trouble with my input file. I have a .xlsx file where i import a bunch of data. Some columns are completely misinterpreted by the tool. For example a column with text is directly interpreted as time column (00:00:00) or a column with date all values are interpreted as 1900-01-10. The input date has following type MM/dd/YYYY.

I know that Alteryx only use one date format and i need to change it with datetimepase but as already all values were changed i need to something before as it already shows in the preview of the input tool the wrong data.

I would be happy if somebody can help me.

grossal

Hi @Joma,

sorry for the last response. My biggest issue right now is that I can't replicate it.

The formatting is might responsible for the issue. It's possible to format a number like 10 as a date and people wouldn't be able to tell the difference between a real date and an integer.

I'd maybe try these things:

1) Import with Headers as rows:

Every columns now starts with a text and Alteryx will try to interpret it as Strings. If the strings are right, you can use the Dynamic Rename and Auto-Field / Select tool to format the rest.

2) Export Excel to CSV and Import CSV

It's probably a nasty solution, but I'd give it a try. 

3) Try to trick Alteryx

We can also try to use the Python tool and just read in the Excel via Pandas and than pass it through to Alteryx, but I am not quite sure if the result is different, but the code is quite simple:

Here is the Code for copy-paste:

from ayx import Alteryx
import pandas as pd

file_path = "C:\_Data\Alteryx\Community\data.xlsx"
data = pd.read_excel(file_path)

Alteryx.write(data,1)

I hope something works. Let me know!

Best

Alex