3516476 - Incorrect field length shows when creating a Data Flow based on Excel data source in SAP Datasphere

Symptom

• Incorrect field length shows when creating a Data Flow based on Excel data source in SAP Datasphere
• The field Data Type is observed as String(2) when it should be String(3)
• The value with 3 strings starts in row 1190. If the column with the noticed value is cut and added into the 2nd row, the data type value is correctly defined. It appears that the system is not checking all fields

Environment

SAP Datasphere

Product

SAP Datasphere all versions

Keywords

SAP Datasphere, Data Flow, Field Length, Data Type String, SFTP, Upload, Metadata, CSV, JSON, Excel, Schema, Adjust Column Definition. , KBA , CA-DI-EMB , Data Intelligence Embedded in Data Warehouse Cloud , DS-DI-DF , Data Flows , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.