Symptom
- Coverting data in format of "HH:MI:SS AM/PM" to time format in Lumira Desktop creates a blank column
Environment
- SAP Lumira Desktop 1.31.x
- Microsoft Windows
Reproducing the Issue
- Import a dataset containing a column with time defined in the format "HH:MM:SS AM/PM" for example "11:10:10 AM"
- Go to the prepare room
- Right click on the column containing the time values and select convert to time
- Click the "OK" button
Cause
- Lumira request the input parameters be in the format "hh:mi:ss".
- The data presented in the format "HH:MM:SS AM/PM" is in a invalid format therefore is not recgonised by Lumira resulting in a blank column.
Resolution
- Ensure the data being converted to time is in the format "hh:mi:ss", for example instead of "11:10:10 AM" the data should be in the format "11:10:10".
See the image below:
Keywords
KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem
Product
SAP Lumira, desktop edition 1.0