Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import CSV file: column count mismatch by always 1

Hello,

I am trying to import data from a CSV file into a HANA db table with an .hdbti file.

I have a large structure of 332 fields in the table. When I activate the files to start the import, I always get the following message:

CSV table column count mismatch. The CSV-file: Test.data:data.csv does not match to target table: Test.data::test. The number of columns (333) in csv record 1 is higher than the number of columns (332) in the table.

But even if I delete the last column in the CSV file, the message stays the same. I also tried adding an additional field in the table on HANA, but then the column numbers in the error message just increase by 1. Then the message is: The number of columns (334) in csv record 1 is higher than the number of columns (333) in the table.

So, it seems, whatever I do, the system thinks always that the csv file has one column too much.

With another smaller structure of 5 fields, the import worked that way.

Do you have an idea what the problem could be?

Regards,

Michael

Tags:
Not what you were looking for? View more on this topic or Ask a question