How to restrict input files columns count

[Karthick461]

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

[Karthick461]

Thanks for your Email @atcodedog05 

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

[atcodedog05]

Hi @Karthick461 

The screenshot is a data issue sadly 😐

Hope this helps : )

[Karthick461]

Hi @atcodedog05 

 Issue with Incoming Data source?

-Karthick.

[atcodedog05]

Yes