error loading csv file - data contains 12 columns, expected 19

[Shekhar Deshin1]

Hello,

I am loading csv file however i am getting error - data contains 12 columns, expected 19

Actual data it starts from row number 3.So i selected properly row 3 while loading data in load data.

For first run it works fine and i got all records properly in target table.

While doing scheduled import,i am selecting same data source and just changing the csv attachment to load further data.It load just 1 row into target table.When i check error it gives me data contains 12 columns, expected 19.

1st row having 19 colums.

2nd row having 3 columns.

3rd row having 12 columns 

actual data starts from row number 4.

How to fix this issue? please suggest.

[Ankur Bawiskar]

Hi Shekhar,

So the data starts from row number 4; where is the header row is it at number 1 or number 3

you can specify in the csv data source what would be your header row etc

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[lmseco]

Shekhar,

Maybe, if it is a custom csv, your csv is not properly created. Have you reviewed that all fields in your csv are properly enclosed into the appropiate field delimiters? Have you checked that the fields themselves do not contain the character used as a field delimiter (delimiters within field values)? Are there any newline character at the end of the csv rows? is it properly included in all of the rows? etc.

Regards,

[Mary T]

I think it will be useful to see a visual sample of the csv