R42520 - Regroup XML data

w2vijay

Well Known Member
Hello Guys,
I am creating BI Publisher report with RTF template based on XML file generated from Pick Slip Report in JD Edwards.The detail lines are generated under "Pick Slip Detail" section instead of "Header_Custom_Section" . Please let me know how to regroup the data. Below is the sample data given.

-<R42520>
-<Pick Slip Detail>
----Header Information ----
-<Header_Custom_Section>
<Pick Slip Number>1002</Pick Slip Number>
<Order Number>1016</Order Number>
--- Detail Line------
<Line Number>1.00</Line Number>
<Item Number>05003</Item Number>
<Qty Shipped>20</Qty Shipped>
-<Pick Slip Detail>
<Line Number>2.00</Line Number>
<Item Number>05004</Item Number>
<Qty Shipped>22</Qty Shipped>
-<Pick Slip Detail>
<Line Number>3.00</Line Number>
<Item Number>05005</Item Number>
<Qty Shipped>22</Qty Shipped>
-<Pick Slip Detail>
<Line Number>4.00</Line Number>
<Item Number>05006</Item Number>
<Qty Shipped>22</Qty Shipped>
-<Pick Slip Detail>
----Second Header -----
-<Header_Custom_Section>
<Pick Slip Number>1003</Pick Slip Number>
<Order Number>1017</Order Number>
<Line Number>1.00</Line Number>
<Item Number>05008</Item Number>
<Qty Shipped>28</Qty Shipped>
-<Pick Slip Detail>
<Line Number>2.00</Line Number>
<Item Number>05009</Item Number>
<Qty Shipped>22</Qty Shipped>
-<Pick Slip Detail>
<Line Number>3.00</Line Number>
<Item Number>05010</Item Number>
<Qty Shipped>22</Qty Shipped>

I want the output as below

Pick Slip Number , Order No
1002 1016
Line Item Qty
1 05003 22
2 05004 25
3 05005 24

Pick Slip Number , Order No
1003 1017
Line Item Qty
1 05008 22
2 05009 25
3 05010 24
 
Top