Hi,
Here I have a huge XML with so many repetition elements like,
<admin>
<quoteback name="caseId">SHAWN AABROWN</quoteback>
<quoteback name="caseId">BROWN</quoteback>
<date_request_completed>08/15/2012</date_request_completed>
<date_request_completed>15/2012</date_request_completed>
</admin>
<claim number="5456767" sequence_number="1" unit_number="1">
<claim number="465476578" sequence_number="2" unit_number="1">
Is there a way apart from separating the XML chunks and placing a separate XML input stage for each of the repetition element. As I said there are 30 repetition elements in the XML and placing so many XML input stages and integrating the data is really tough.
Repetition Elements in XML
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 96
- Joined: Mon May 14, 2012 1:30 pm
Repetition Elements in XML
Thanks,
Ankur Saxena
Ankur Saxena
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What exact version are you running? Is this a server job (as marked) or a parallel job (as posted)? No point our trying to guess this information, which will affect the answer we give.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 96
- Joined: Mon May 14, 2012 1:30 pm
Each repeating node needs its own "output link"....not its own stage. You can have one xmlInput Stage (or xml stage for anyone reading this that has 8.5+ and wants to use the xml stage) with as many output links as you want...... you want to parse the xml only once...but each separate repeating node needs its own link --- as though it was its own relational table...one might have (say) 3 rows and the other might have 300.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Each repeating node needs its own "output link"....not its own stage. You can have one xmlInput Stage (or xml stage for anyone reading this that has 8.5+ and wants to use the xml stage) with as many output links as you want...... you want to parse the xml only once...but each separate repeating node needs its own link --- as though it was its own relational table...one might have (say) 3 rows and the other might have 300.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am