Oracle Fusion Data Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Fusion Data Intelligence Idea Lab

Categories

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

EDM to FAW support for CSV with comma in data values and double quotes qualififer

Needs Votes
24
Views
3
Comments
Ian Cosinas
Ian Cosinas Rank 3 - Community Apprentice
edited December 2024 in Oracle Fusion Data Intelligence Idea Lab

There is a current issue in EDM to FAW data augmentation where it does not support quote qualifier from the EDM CSV extract.

Also, it does not process/parsed the data properly if a value of a column has comma.

This is a fundamental feature that should be included in any type of data ingestion.

Tagged:
1
Up
1 votes

Needs Votes · Last Updated

Comments

  • Krishna Prasad Kotti-Oracle
    Krishna Prasad Kotti-Oracle Mod

    Are you using FAW Connector and can you let me know can share a screenshot just showing the issue ?

  • Ian Cosinas
    Ian Cosinas Rank 3 - Community Apprentice

    Yes we are using FAW connector and performed data augmentation.

    This is proven to be an issue and acknowledge by Oracle support. Oracle SR was raised - SR 3-36495014361

    See below sample:

    Description should be “Overtime, Ambulance TP Call Out”. As you can see the actual value has comma. So, data augmentation cannot parse it properly since the file extract didn’t have the double quote.

    image.png

  • Krishna Prasad Kotti-Oracle
    Krishna Prasad Kotti-Oracle Mod

    Thank you for the update. We are looking into the possibility of adding support for comma-separated values. Thanks