XSlt Code help
Posted: Tue Mar 27, 2012 4:57 am
Hello Experts.I need to create a xslt code for coverting the below xmls.
I have a source xml as below
<Header>
<FoodDietData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>20</DietCode>
<FoodDietData>
<FoodDietData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>95</DietCode>
<FoodDietData>
<FoodDietData>
<GTIN>230</GTIN>
<DietType>H&WB</DietType>
<DietCode>50</DietCode>
</FoodDietData>
</Header>
The output xml should be as follows.
For the same GTIN numbers
and DietType = H&WB in the source xml ,this should be clubbed together under CINXml tag as below.
<CINXml>
<Food&BeverageData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>20</DietCode>
</Food&BeverageData>
<Food&BeverageData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>95</DietCode>
</Food&BeverageData>
</CINXml>
<CINXml>
<Food&BeverageData>
<GTIN>230</GTIN>
<DietType>H&WB</DietType>
<DietCode>50</DietCode>
</Food&BeverageData>
</CINXml>
Please give some light on this.
I have a source xml as below
<Header>
<FoodDietData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>20</DietCode>
<FoodDietData>
<FoodDietData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>95</DietCode>
<FoodDietData>
<FoodDietData>
<GTIN>230</GTIN>
<DietType>H&WB</DietType>
<DietCode>50</DietCode>
</FoodDietData>
</Header>
The output xml should be as follows.
For the same GTIN numbers

<CINXml>
<Food&BeverageData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>20</DietCode>
</Food&BeverageData>
<Food&BeverageData>
<GTIN>123</GTIN>
<DietType>H&WB</DietType>
<DietCode>95</DietCode>
</Food&BeverageData>
</CINXml>
<CINXml>
<Food&BeverageData>
<GTIN>230</GTIN>
<DietType>H&WB</DietType>
<DietCode>50</DietCode>
</Food&BeverageData>
</CINXml>
Please give some light on this.