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.
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?
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.
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
Hi @User_UL61Z, Could you please provide the solution for this. We are trying to implement something similar to this
Hi, any solution for this?
Can you please provide a screenshot showing what is the current vs expected output with one example
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.
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: https://community.oracle.com/customerconnect/discussion/585089/otbi-locating-5th-occurrence-of-character-using-substring-and-locate?utm_source=community-search&utm_medium=organic-search&utm_term=locate+substring
Very helpful information.
Thanks for sharing @Rich Merkel!
Hi @Rich Merkel that worked and thank you
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
Hi team, I would like to add the work order notes to my work order schedule calendar, but I'm unable to find where these notes are stored and what otbi subject to use to access them. Be great if I can be pointed in the right direction, thanks
