BI Publisher (MOSC)

MOSC Banner

How to count the distinct values in the XML extract? for eText template.

edited Aug 30, 2024 2:19PM in BI Publisher (MOSC) 6 commentsAnswered ✓

Hi,

How do we count the distinct values in the particular node in XML for eText?

For e.g.

I have an extract that looks like..

<OutboundPayment>

     <BankAccount>

          <BankAccountNumber>1234</BankAccountNumber>

     </BankAccount>

     <BankAccount>

          <BankAccountNumber>5678</BankAccountNumber>

     </BankAccount>

     <BankAccount>

          <BankAccountNumber>1234</BankAccountNumber>

     </BankAccount>

</OutboundPayment>

Now, here I have a requirement to count number of distinct values under /OutboundPayment/BankAccount/BankAccountNumber/

How can I accomplish that? in eText?

Regards,

Aniket

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center