Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Groups in rtf template

Received Response
12
Views
2
Comments

Summary

Groups in rtf template

Content

Hi,

 

I have this XML data :

 

<PARENT_GROUP> 

   <CHILD_GROUP_1>

      <DATA_11> DEP1 </DATA_11>

      <DATA_12> DEP2 </DATA_12>

      <DATA_13> 2 </DATA_13>

      <DATA_14> 4 </DATA_14>

   <CHILD_GROUP_1/>

 

   <CHILD_GROUP_2>

        <DATA_21>ABC</DATA_21>

        <DATA_22> 100 </DATA_22>

        <DATA_23> DEP1 </DATA_23>

   <CHILD_GROUP_2/>

 

   <CHILD_GROUP_2>

        <DATA_21> XYZ </DATA_21>

        <DATA_22>  200 </DATA_22>

        <DATA_23> DEP2 </DATA_23>

   <CHILD_GROUP_2/>

 

<CHILD_GROUP_2>

        <DATA_21> PQR </DATA_21>

        <DATA_22>  300 </DATA_22>

        <DATA_23> DEP1 </DATA_23>

   <CHILD_GROUP_2/>

 

<CHILD_GROUP_2>

        <DATA_21> LMN </DATA_21>

        <DATA_22>  400 </DATA_22>

        <DATA_23> DEP2 </DATA_23>

   <CHILD_GROUP_2/>

 

</PARENT_GROUP>

 

It should display like :

 

ITEM             

           

QUANITY TAX NAME TAX QNT
DEP1 2

ABC

 

PQR

100

 

300

DEP2 4

XYZ

 

LMN

200

 

400

How will i do that?

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    use left grouping while creating rtf template instead of above grouping, duplicates rows will suppress. if you still find issues, please upload template and xml.Thanks

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead

    That XML doesn't look right to me.
    Either way, you should just be able to nest your groups to achieve what you want.
    I know I have done something similar in the past however i'm out of the office so can't get you the exact syntax.