If an explanation helps, I can explain the behavior. As for Excel, I'll put in my two cents.
If your data looks like:
Excel might parse this out with a blank field name and show NULL values appropriately. Excel would also parse out this row incorrectly:
It would move Michigan into the phone field because of the extra |.
When data is expected to conform to a consistent format, Alteryx prevents you from loading the data when the wrong count of fields is encountered.
If you post a file with the first 2 or 3 records only. I'd be happy (or one of many others helping here) to take a look and see what we recommend specifically for you. My first priority is to help you with the issue. Once that is done, an idea for future enhancements can be made to be more forgiving of delimited files and allow the data to be read with caution.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return. Please Subscribe to my youTube channel.
Generally this error occurs because the field length on input is too short, causing truncation of the data. If you increase the Field Length in the input tool and read in the file with no delimiters (delimiter = \0), you should be able to read the entire file in. Then, you can use a Text to Columns tool to parse out on the pipe.
Sophia Fraticelli Senior Solutions Architect Alteryx, Inc.
I appreciate your response but the KB article is not that helpful. Since I have more header fields than data fields, according to the article I should...
just get a warning like this: 'Warning: Input Data (1): Record #6: Not enough fields in record' And the last record in the third field (sic--presumably he means the third field in the last record) will just be null.
But that's not what's happening. I would be fine with that. What is actually happening is that I get an error message and no data is loaded.
I tried loading the file without delimiters and then using the Text to Columns tool but then all the fields are named Field1, Field2, ... FieldN.
How would I recover the field names from the original header row?