Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle DV Desktop - How to change data from text to date in GUI

Received Response
21
Views
1
Comments
EgonM-Oracle
EgonM-Oracle Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

How to convert text fields into dates with data that has null or "-" or ""

Content

Hi, I'm new to DV and coming up against some issues with the data set I've imported to a new project.  Using the DV Desktop app - when looking at the table of data and I click on the column header I get some options.  One of those options is to "Convert to Date...".  I then get a popup window and when I try to convert the data I face a number of issues.

1) First issue is that the convert option fails as it can't handle "" or null data fields.
2) Second issue is the date conversion is very limited and doesn't support the valid date data that exists in the field such as, failing on "9-Jan-17" for a date format of "dd-MMM-yy"  - (it of course works fine for dates that have 2 digits for the dd part such as 19-Jan-17).  I've tried other date formats but to no avail.

Any help would be great!

Cheers

DV-error1.png

Tagged:

Answers

  • EgonM-Oracle
    EgonM-Oracle Rank 2 - Community Beginner

    Solved - it was a data quality issue.  Once I changed the CSV data to have all dates as dd-MMM-yy format, I am able to convert the field to a date field without issue. 

    Somewhat surprising the Oracle DV app doesn't support this no doubt very common data convert issue, ie automatically from d-MMM-yy to dd-MMM-yy