Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to list items Comma Separated in BIP for Word RTF?

Summary
How to list items Comma Separated in BIP for Word RTF?
Content
Hi All,
I have data that currently lists in a table as
AAE
AAP
AID
AMD
AOB
ARC
ARD
ARN
BPD
CCM
CDB
CDV
CE
CMD
CRD
CSD
CVE
I'd like it to list comma separated as a paragraph instead like this:
AAE, AAP, AFT, ARN, BPD, CCM, CDB, CDV, CE, CEN, CMD, CRC, CRD, CVE
How can I do this in BI Publisher for Word RTF?
Thanks,
John
Answers
-
Thanks Sven,
I ended up using your SQL listagg in a PS Query expression. Works great.
John
0 -
There are two different ways...
Do it in the data model (more efficent ):
<span class="kwd">select</span><span class="pln"> listagg</span><span class="pun">(</span>element<span class="pun">,</span><span class="str">', '</span><span class="pun">)</span><span class="pln"> </span><span class="kwd">within</span><span class="pln"> </span><span class="kwd">group</span><span class="pun">(</span><span class="kwd">order</span><span class="pln"> </span><span class="kwd">by</span><span class="pln"> group_set</span><span class="pun">)</span><span class="pln"> csv<br/> </span><span class="kwd">from</span><span class="pln"> table</span><span class="pun">;</span>
Do it in the template:
<?for-each:GROUP_SET?><?ELEMENT?>, <?END FOR-EACH?>
Publisher will repeat everything inside the FOR-EACH-TAG as often as there are GROUP_SETs to loop over.
0