Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 230 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How do I convert comma separated values to columns in OTBI Report
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
-
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?
0 -
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.
0 -
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
0 -
Hi @User_UL61Z, Could you please provide the solution for this. We are trying to implement something similar to this
0 -
Hi, any solution for this?
0 -
Can you please provide a screenshot showing what is the current vs expected output with one example
0 -
We have the same requirement. We have an invoice description that contains critical references that we need to display in separate columns. The invoice description is one column in OTBI. How do we get it to separate out into a column per data item as separated by commas.
0 -
I would suggest using locate and substring formulas.
Uses locate function to find position of the comma, then use substring function while using the position # from locate.
Similiar to:
1 -
Very helpful information.
Thanks for sharing @Rich Merkel!
1
