Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to display delimited value in a column into multiple rows in obiee 11g
3519772
Rank 1 - Community Starter
Hi,
Help required for converting pipe delimited values in a column to rows obiee 11g. Data in the column is as below.
| 10983,7914,Robert Scott,Mallory,2275.00,11,7010,862,750,761,00000,Laz Parking 845,05-Jun-17,07-Jun-17,20-Jun-17,June parking for 7 as per contract with customer BT Conferencing,23896875.pdf|23896888.pdf|23896909.pdf,USD,H104320170608gyqqqhluf |
Thanks,
Prashanth.
0
Answers
-
That's a DB issue and not an OBIEE one. You will need to get the "rows" in the result set - i.e. produced by the RPD - already.
Best use the CONNECT BY function of the Oracle database if you have one underneath:
https://stackoverflow.com/questions/38371989/how-to-convert-comma-separated-values-to-rows-in-oracle
0