SAP Data Warehouse Cloud – Import CSV in table, an error occurs

[#1]

Hey all,

I want to create a table from a CSV file.

I was unable to create the table from the origin CSV file, because the file exceeded the size limit of 200MB.
So I have split the file into 2 files and created the table via the import function in the Data Builder. Afterwards I open the table definition and tried to import the second file via the import function, but when I try this, I get an error, because of the date value is not allowed. For testing reasons, I tried to import the first file again (deleting existing entries before), but I also get the same error.

Here is the table definition and the import button. DD/MM/YYYY is the correct format.

And here is the error message. The line is the first line of the file.

Does someone know, how to solve this, because I don’t get any hint from the error message.

Regards

Severin

[XaviPolo]

It seems to be a product error.
When adding a CSV to create a table, it allows to use several formats, but when adding data from a CSV to an existing table, it only accepts the format YYYYYYMMDD (and variants). Open an incident in SAP Support

You can import the 2 CSVs in two different tables and join them in one view or via a Data Flow.

[severin_thelen]

Thanks for you answer.

My solution was to change the datetype of the field 'Date' to string and convert the type in a view to date.
But your solution should also work.