Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Disperse groups
Alexander Restrepo
Rank 3 - Community Apprentice
Summary
Disperse groups
Content
Hi All,
I have 3 groups 1 header, 1 details, and 1 totals.
The XML file generated, its exporting each group as group itself at the same level header, details and total.
I need to show header then details, and finally total for each group.
Please check the attached documents for reference.
I got something like
<Header>
headfield1
headfield2
</Header>
<Details>
Detail1
Detail2
Detail3
</Details>
<Total>
total
</Total>
I need a excel output similar to the jpg file
Thanks
0
Answers
-
You need to change the way you are generating your XML.
Please generate the XML as below way
<Header1>
<Detail1>
</Header1>
<Header2>
<Detail2>
</Header2>
<Header3>
<Detail3>
</Header3>
.
.
.
.<Total>
</Total>
0