cancel
Showing results for 
Search instead for 
Did you mean: 

date & time column has the data in the format xx:xx.x

while importing data from CSV , date & time  column has the data in the format xx:xx.x (e.g. 03:45.7).  However I import this into Excel, it will always import it as a time.

 

my steps action done with no success :

1. change  type to time/date - lead to error

2. detect data type - lead to error 

3. change CSV encoding type - not change csv_BI.JPGget data from CSV in BIcsv_excel.JPGGet Data from CSV in Excel

Status: Needs Info
Comments
Community Support Team

Hi @yairzafrany,

 

What's the format of these columns in the CSV? Can you share a sample please?

 

Best Regards,

Dale

Established Member
Status changed to: Needs Info