MANUAL Upload of .csv file and error of invalid data type is observed in SAP Process intellgence

[former_member1299424]

Hi, While doing the manual upload, the error of "VARCHAR" data type for a column with values of Datetime is coming, we have prepared the column as per the standard column as defined in the user guide " DD-MM-YYY HH:MM:SS.SSSZ".

The error we are facing is while executing " Run T&L" is "Error Executing Transformation Processor EVENT - (Column c_time has an unexpected type -> VARCHAR)", we have already tried these possible solutions:

1. Maintaining the Data type of c_time column as "datetime"
2. Using cast function for c_time column
3. without using the c_time column while mentioning the SQL script.

Why are we not able to transform from the .csv file uploaded?

The preview of the data is visible in the SQL Script written, if the c_time COLUMN is removed from the script.

What is the issue? What and were the data needs to be defined? why the cast is not working? what is to be done?

Thanks in advance,

Shrutee S.

[former_member1291121]

Few thoughts...

Did you try bringing in as varchar, adding additional transformation as next step to cast and connect to final destination your table.

File > transformation> table?

Table has it as datetime?

[fabioferrari]

Hi Shrutee, in this documentation you can find our recommendation approach how to ingestion timestamps via manual upload https://documentation.signavio.com/suite/en-us/Content/process-intelligence/etl-new-manual-upload-ov...
You can either ingest timestamps in the 3 supported formats (date, timestamp, time) or as varchar as you did. In the process data model, to create the c_time column, you then need to cast your column to get to a TIMESTAMP data type as supported by the Presto SQL documentation. Here the link https://prestodb.io/docs/current/

I tried to search for some help there and it looks like this link can he helpful for your use case https://prestodb.io/docs/current/functions/datetime.html#date_parse