CSV file import: column count mismatch

[Former Member]

Hello,

I'm trying to import data to Hana through a .hdbti file, when i try and activate the file i get the following error:

miCsv.csv does not match to target table: gbi-student-819.gbi.data::GBI_819.CENTROSEGUROS.SEGUROS. The number of columns (35) in csv record 198 is higher than the number of columns (34) in the table.

i tried taking out columns from the csv, and i also tried adding columns to my table, none will work.

I can't actually tell what the problem is, if anybody can tell please let me know.

Thank you all very much.

[former_member456023]

Please make sure your import operation meets the CSV Data File Constraints

The following constraints apply to the CSV file used as a source for the table-import feature in SAP HANA XS:

• The number of table columns must match the number of CSV columns.
• There must not be any incompatibilities between the data types of the table columns and the data types of the CSV columns.
• Overlapping data in data files is not supported.
• The target table of the import must not be modified (or appended to) outside of the data-import operation. If the table is used for storage of application data, this data may be lost during any operation to re-import or update the data.