Oracle Analytics and AI

Vaishnavi

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?

Venkat Thota - BIP

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