Invalid date when import a excel file which include scientific notation in SAC
SAP Analytics Cloud (Enterprise) 2020.7.0
Reproducing the Issue
- Logging into SAC.
- Click Main Menu.
- Click Create.
- Click Model.
- Click Import a file from your computer.
- Click Select Source File, select an excel file which include scientific notation, the attachment Sample.xlsx can be used.
- Click Import.
- Click OK.
- In Draft Data, select the file which is just imported.
- Click Validate Data, in the Mode Requirements, the column which include scientific notation is detected with data quality issues.
When a file is uploaded we sample the first 5000 rows of the file to infer data types of the columns (One reason is related to performance). If there is no data in the first 5000 rows in the file, then will facing data quality issue.
Moving a row with the decimal numeric value for columns which are facing data quality issue into the first 5000 rows of the excel file.
KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Product Enhancement