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.