Forum Discussion

mjain's avatar
mjain
New Contributor
6 years ago
Solved

Extra column Error

Hi everyone , I am facing once error while parsing data from CSV parser. It is showing me one error “The number of CSV data fields is greater than the number of header columns in the input data”. ...
  • pratiksha_patil's avatar
    pratiksha_patil
    6 years ago

    Hi mjain,

    You need to change few configuration in CSV Parser. Add column names in the column fields and Skip lines fields to 1 which will remove the csv file field name and replace with the column names you specified.Also need to uncheck Contains headers and add Header size error policy to Trim record to fit header.
    Hope this resolve your issue.

    Thanks,
    Pratiksha

pratiksha_patil's avatar
pratiksha_patil
New Contributor II
6 years ago

Hi mjain,

You need to change few configuration in CSV Parser. Add column names in the column fields and Skip lines fields to 1 which will remove the csv file field name and replace with the column names you specified.Also need to uncheck Contains headers and add Header size error policy to Trim record to fit header.
Hope this resolve your issue.

Thanks,
Pratiksha

  • mjain's avatar
    mjain
    New Contributor
    6 years ago

    Thank it works.