XML transformation issue
Posted: Wed Oct 30, 2013 11:54 am
Hi All,
My xml file look like below,
<Parent>
<Id>A1</Id>
<Sid>A1id</Sid>
<Group>
<lov type="time">
<id1>1</id1>
<desc>US</desc>
</lov>
<lov type="loc">
<id1>2</id1>
<desc>US</desc>
</lov>
</Group>
</Parent
<Parent>
<Id>B1</Id>
<Sid>B1id</Sid>
<Group>
<lov type="time">
<id1>11</id1>
<desc>US</desc>
</lov>
<lov type="loc">
<id1>12</id1>
<desc>US</desc>
</lov>
</Group>
</Parent
and if i take the
1. "id" as the key field (repetition element), from the lov type one is missed out. Only "time" has been take for processing. and "loc" has been dropped.
2. But if i take the "type" as the key field i am getting the id value same for all the records.
Let me know if transformations are needed.
Please help me to solve this issue.
Thanks!
My xml file look like below,
<Parent>
<Id>A1</Id>
<Sid>A1id</Sid>
<Group>
<lov type="time">
<id1>1</id1>
<desc>US</desc>
</lov>
<lov type="loc">
<id1>2</id1>
<desc>US</desc>
</lov>
</Group>
</Parent
<Parent>
<Id>B1</Id>
<Sid>B1id</Sid>
<Group>
<lov type="time">
<id1>11</id1>
<desc>US</desc>
</lov>
<lov type="loc">
<id1>12</id1>
<desc>US</desc>
</lov>
</Group>
</Parent
and if i take the
1. "id" as the key field (repetition element), from the lov type one is missed out. Only "time" has been take for processing. and "loc" has been dropped.
2. But if i take the "type" as the key field i am getting the id value same for all the records.
Let me know if transformations are needed.
Please help me to solve this issue.
Thanks!