CSV data fields is greater than Header size

Designing Pipelines
#1

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 .

image
image455×554 9.35 KB

My CSV parser property:

image
image671×553 25.4 KB

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

#2

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

image
image771×153 4.65 KB

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