Too Many Fields in record # 23953

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

Input

Text Mining

Accepted answers

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.

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

All comments

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.

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

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

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

Sorry typo - record size = 1024

Quick Links

Tags

This months top contributors

Hollingsworth 335