Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How do I convert comma separated values to columns in OTBI Report

Received Response
124
Views
6
Comments
User_UL61Z
User_UL61Z Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Hi Team,

How do I convert comma separated values to columns in OTBI Report.

For eg- We have created a multiple select choice list field and data is showing in comma separated values in a row. We need to convert it into columns in OTBI report.

Answers

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    Is the CSV data coming in from a file or held in a database table field?

    Can use instr to search for the comma and substr to extract the data between located comma's. Is the data free text i.e. is it possible that the text contains commas as part of the text entry?

  • User_UL61Z
    User_UL61Z Rank 1 - Community Starter

    It is a multi select choice list which we have created. If a user has selected multiple values for that field on the UI, then it is showing value in report separated by comma.

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    It's been a while, trying to picture what you mean, in the past I've read the selections into a variable and combined using a filter

  • Siva Sai Preethi Gajula
    Siva Sai Preethi Gajula Rank 1 - Community Starter

    Hi @User_UL61Z, Could you please provide the solution for this. We are trying to implement something similar to this

  • Kelvin Jamil Reyes
    Kelvin Jamil Reyes Rank 1 - Community Starter

    Hi, any solution for this?

  • ravikiran goda-Oracle
    ravikiran goda-Oracle Rank 5 - Community Champion

    Can you please provide a screenshot showing what is the current vs expected output with one example