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

Difference in date format between .xlsx and .csv file in obiee 12c

Received Response
72
Views
15
Comments
2»

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    Looks like an Excel issue and how it is interpreting your "date". OBIEE is doing what it has to but and it appears to be exporting it correctly as "17-Nov".

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Again: that is Excel. Meaning it interprets the data. it is NOT what's literally IN the csv!

    In order to know what is in the CSV you have to open it with Notepad or the likes. And NOT with a tool with INTERPRETS the data.

    Not really sure how else to say this.

  • 3364275
    3364275 Rank 2 - Community Beginner

    Hi Christian,

    If i open the .csv file in notepad++ it showing the correct value as "Nov-17".

    Thanks,

    Somi

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    So? Connect what I said with what you see.

    Excel. Interprets. The. Data.

    Your. Export. Is. Correct.

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    Hi Somi,

    Oracle did not write excel.

    Microsoft are responsible for that one.

    If you create a comma delimited file and manually populate it with data like; -

    SomeText,Nov-17,Somemore text

    Then save it as a .csv extension.

    Then open it in excel.

    You will see that excel misinterprets your field. Excel misinterprets. There is nothing wrong with the source.