2486420 - Converted column with blank data in Lumira Desktop

SAP Knowledge Base Article - Public

2486420 - Converted column with blank data in Lumira Desktop

Symptom

  • Coverting data in format of "HH:MI:SS AM/PM" to time format in Lumira Desktop creates a blank column
    time_fail.JPG

Environment

  • SAP Lumira Desktop 1.31.x
  • Microsoft Windows

Reproducing the Issue

  1. Import a dataset containing a column with time defined in the format "HH:MM:SS AM/PM" for example "11:10:10 AM"
  2. Go to the prepare room
  3. Right click on the column containing the time values and select convert to time
  4. 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:
    time_correct.png

Keywords

KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0