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
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
We would like to understand the reason for the difference in configuration options for the “Send Message to Team” action across the Redwood VBCS Recruiting pages. Currently, we observe the following behavior: On the Job Requisition and Job Requisition List pages, it is possible to hide/remove the “Send Message to Team”…
Is there a way to extract existing BIP reports saved in a specific folder? Like can capture Report Name, Report Path and Owner for example?
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
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…
