XML Output stage
Posted: Wed Sep 22, 2010 4:47 pm
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
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