Hey my Flat File Looks like this
C1002 PNUT1002 U1001
C1002 PNUT1002 U1002
C1002 PMIS1004 U1004
CM04 P3000005 U1005
The XML Output should look like this
<Case Details>
<Case>
<CaseID>C1002 </CaseID>
<Pakage>
<PakageID>PNUT1 002 </PakageID>
<Unit>U1001</Unit>
<Unit>U1002</Unit>
</Pakage>
<Pakage>
<PakageID>PMIS1 004 </PakageID>
<Unit>U1004 </Unit>
</Pakage>
</Case>
<Case>
<CaseID>CM04</CaseID>
<Pakage>
<PakageID>P3000 005 </PakageID>
<Unit>U1005 </Unit>
</Pakage>
</Case>
</Case Details>
I can't able to produce the XML in this format rather it is coming like every unit will have pakage ID and Case ID .Can any define any method to get the output in this format .
C1002 PNUT1002 U1001
C1002 PNUT1002 U1002
C1002 PMIS1004 U1004
CM04 P3000005 U1005
The XML Output should look like this
<Case Details>
<Case>
<CaseID>C1002 </CaseID>
<Pakage>
<PakageID>PNUT1 002 </PakageID>
<Unit>U1001</Unit>
<Unit>U1002</Unit>
</Pakage>
<Pakage>
<PakageID>PMIS1 004 </PakageID>
<Unit>U1004 </Unit>
</Pakage>
</Case>
<Case>
<CaseID>CM04</CaseID>
<Pakage>
<PakageID>P3000 005 </PakageID>
<Unit>U1005 </Unit>
</Pakage>
</Case>
</Case Details>
I can't able to produce the XML in this format rather it is coming like every unit will have pakage ID and Case ID .Can any define any method to get the output in this format .