Too Many Fields in record # 23953

[kashan]

I have CSV File and i can see in preview but when I try to run in the workflow to summarize or any task get this error .

When any why Alteryx gives this error message never seen this in using alteryx last 5 years.

Input Data (5) Error reading "C:\Users\xxxx\Downloads\MAP_BASE_ILCL.txt": Too many fields in record #23953

MARKET ACCT_MAP_GRP ACCT_NUM_LINES_GRP ACCT  SBSCR  MIN
SF  MAP MIX    4 IL xxxxxx011 3xxxxxxxx

[CharlieS · Accepted solution]

Hi @kashan 

This typically happens when the character being used as the delimiter for the file is found in a field value. There's a few ways to resolve this, if it's just this one record then manually correcting the value is typically easiest. 

If the file is something you can share here, I'm sure the Community could help figure out a plan of action. 

[kashan · Accepted solution]

It solved by just changing the field length and treat read errors as warning checks. 

[Paulomi]

Hi, @kashan I'm curious to know what you kept the field size as? I'm facing a similar issue. 

[jos]

this worked for me - I set the file size 10 1024 (just pick any number no logic to it)

[jos]

Sorry typo - record size = 1024