We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks

How to restrict input files columns count

Karthick461
8 - Asteroid

Hi,

 I am reading around 400 txt files from common share. Each txt files having 100000 records. Out of 400 , around 7 or 8 has additional columns with no header. its just # as additional column at only one record of row. so when i run the files, I am getting error as "Too many fields at 11848 line" like this.

 

when i manually open that particular txt files and clear # means, then its working. but its repeated process for me. 

 

Is there any way we can avoid this like take only 14 columns and ignore remaining.. like this  , do we have any option

 

 

13 REPLIES 13
Karthick461
8 - Asteroid

Thanks for your Email @atcodedog05 

 

But in the result , few field names are not populating . Is there any restrictions for that. ?

 

Karthick461_0-1643221096840.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Karthick461 

 

The screenshot is a data issue sadly 😐

 

Hope this helps : )

Karthick461
8 - Asteroid

Hi @atcodedog05 

 

 Issue with Incoming Data source?

 

-Karthick.

atcodedog05
22 - Nova
22 - Nova

Yes

Labels
Top Solution Authors