Hi , I am writing data to xml file. we get data from different tables and needs to append the different xml chuncks from different tables to final xml.
I have 2 records coming from the incoming process
2 records have same amount- the oout put from the xml is like this,
<CvrTypeInfo>
<CvrPlanName>DENTAL</CvrPlanName>
<CvrPlanName>MEDICAL</CvrPlanName>
<SubTotalAmt>20</SubTotalAmt>
<CvrMbrInfo>
<CvrMbr>SUB, SPOUSE</CvrMbr>
</CvrMbrInfo>
</CvrTypeInfo>
but I need like this
<CvrTypeInfo>
<CvrPlanName>DENTAL</CvrPlanName>
<SubTotalAmt>20</SubTotalAmt>
<CvrMbrInfo>
<CvrMbr>SUB, SPOUSE</CvrMbr>
</CvrMbrInfo>
</CvrTypeInfo>
<CvrTypeInfo>
<CvrPlanName>MEDICAL</CvrPlanName>
<SubTotalAmt>20</SubTotalAmt>
<CvrMbrInfo>
<CvrMbr>SUB, SPOUSE</CvrMbr>
</CvrMbrInfo>
</CvrTypeInfo>
Ccan you plese suggeste me how to achheive this. if the amounts are different I am getting what I want, but if the amounts are same. I am not
Thanks in advance
XML Output stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 1
- Joined: Wed Jun 25, 2008 1:29 am
- Location: bangalore
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: