You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

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

Received Response
14
Views
1
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 1 comment

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!