Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Data Type in a Data Flow

Received Response
51
Views
2
Comments
Abhishek Bagh
Abhishek Bagh Rank 4 - Community Specialist
in Oracle Analytics Forum

Summary

how do we change Data Type of a field (which is a date field, say Employee Start Date) from String to Numeric while creating a data flow.

Tagged:

Answers

  • Neeti Choksi-Oracle
    Neeti Choksi-Oracle Rank 5 - Community Champion

    You can add a new column with CAST function on the original column.

  • User_FF4E6
    User_FF4E6 Rank 1 - Community Starter

    Hi,

    You can also do it as data preperation phase on the dataset by right clicking on the particular string attribute and choosing "Convert to Date". You will have an option to choose the date format.