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