Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
5 years ago

CSV data fields is greater than Header size

Hi Gooday,

I tried reading a csv file from smb server through csv parser . The parser throws the error like “Error parsing at record 6478, content-The number of CSV data fields is greater than the number of header columns in the input data: number of CSV data fields = 23, number of header columns = 22”

But when I inspected the file the header size is 22 and there is no extra field value which spills beyond the last header name . Can someone guide how to resolve this error . Also I attach the screenshot of the error in comparision view and also , I attached the sample csv sheet here .

My CSV parser property:


20210603_AZ_Veeva_Activity_Call_Detail_OUTBOUND_IN.xlsx (727.0 KB)

Since the csv is not supported here for the upload , I uploaded in xlsx . Kindly do the needful.

Thanks,
Harshavardhana

1 Reply

  • Harsha3's avatar
    Harsha3
    New Contributor III
    5 years ago
    Copy LinkReport

    On observing further , the extra delimiter was added after the last header .

    Whereas there are only 22 fields which are mapped and not sure why the extra delimiter was added at the last thereby it is considered as an additional field here and causing concern while reading the file .

    Thanks,
    Harshavardhana