Fixed Width File Import-Unknown Field Type Error

Question

Hi,

I am trying to import a fixed width file into Alteryx. I want to use the import option to designate my column names, types, and lengths.

When I import ( tried with XML and flat file types) I get an "Unknows Field Type Error". I have specified my data types to be V_String and Int32...both valid datatypes in Alteryx....help?

Thanks!

Typeless in Seattle

pcatterson · Accepted Answer

You don't give a lot of indication what is going wrong, but I think I might have an idea.

When I was pulling in fixed width data for the first time, my first errors were data type errors due to badly formatted numbers.  There was padded whitespace around the number which was confusing Alteryx.

I'd initially pull everything in as strings and convert to numbers later in the workflow.  Let me know if that helps.