Home » Fusion Middleware & Colab Suite » Business Intelligence » BI Publisher RTF Template Builder (BI Publisher)
BI Publisher RTF Template Builder [message #687529] Tue, 28 March 2023 15:59 Go to next message
VariableReset
Messages: 3
Registered: November 2016
Junior Member
Does anyone know how to suppress duplicate rows from a for-each loop? I can't touch the underlying xml data, nor can I edit the sql that produces the xml file, so I am stuck with duplicate rows in one of the tables generated.

Any guidance on this?
Re: BI Publisher RTF Template Builder [message #687548 is a reply to message #687529] Fri, 31 March 2023 00:14 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
nor can I edit the sql that produces the xml file
And that's exactly what I first thought when I read you have duplicates. Unfortunately, I wouldn't know how to do it (or whether it is possible!) in tool you use; it's just data you get, and that's more or less garbage in, garbage out.

If you can't edit query, ask the ones - who can - to do it.
Previous Topic: group every 5 records
Next Topic: oca user session information
Goto Forum:
  


Current Time: Thu Mar 28 08:16:26 CDT 2024