My requirement is I have to read a input xml which has the structure as below:
<Segment-ST>
<Element-143>852</Element-143>
<Element-329>0001</Element-329>
</Segment-ST>
<Segment-XQ>
<Element-305>H</Element-305>
<Element-373>20140105</Element-373>
<Element-373_1>20140111</Element-373_1>
</Segment-XQ>
<Loop-LIN>
<Segment-LIN>
<Element-350>001</Element-350>
<Element-235>UP</Element-235>
<Element-234>722868102237</Element-234>
<Element-235_1>VP</Element-235_1>
<Element-234_1>F2N036-06</Element-234_1>
</Segment-LIN>
<Loop-ZA>
<Segment-ZA>
<Element-859>QS</Element-859>
</Segment-ZA>
<Segment-SDQ>
<Element-355>EA</Element-355>
<Element-66>92</Element-66>
<Element-67>008</Element-67>
<Element-380>1</Element-380>
<Element-67_1>018</Element-67_1>
<Element-380_1>1</Element-380_1>
<Element-67_2>027</Element-67_2>
<Element-380_2>1</Element-380_2>
<Element-67_3>044</Element-67_3>
<Element-380_3>-1</Element-380_3>
</Segment-SDQ>
</Loop-ZA>
</Loop-LIN>
<Loop-LIN>
<Segment-LIN>
<Element-350>002</Element-350>
<Element-235>UP</Element-235>
<Element-234>722868127469</Element-234>
<Element-235_1>VP</Element-235_1>
<Element-234_1>F2N025-10-GLD</Element-234_1>
</Segment-LIN>
<Loop-ZA>
<Segment-ZA>
<Element-859>QA</Element-859>
</Segment-ZA><Segment-SDQ>
<Element-355>EA</Element-355>
<Element-66>92</Element-66>
<Element-67>007</Element-67>
<Element-380>1</Element-380>
<Element-67_1>010</Element-67_1>
<Element-380_1>1</Element-380_1>
<Element-67_2>017</Element-67_2>
<Element-380_2>1</Element-380_2>
<Element-67_3>020</Element-67_3>
<Element-380_3>1</Element-380_3>
<Element-67_4>021</Element-67_4>
<Element-380_4>1</Element-380_4>
<Element-67_5>022</Element-67_5>
<Element-380_5>1</Element-380_5>
<Element-67_6>025</Element-67_6>
<Element-380_6>1</Element-380_6>
<Element-67_7>028</Element-67_7>
<Element-380_7>2</Element-380_7>
<Element-67_8>048</Element-67_8>
<Element-380_8>1</Element-380_8>
</Segment-SDQ>
<Segment-SDQ>
<Element-355>EA</Element-355>
<Element-66>92</Element-66>
<Element-67>003</Element-67>
<Element-380>9</Element-380>
<Element-67_1>005</Element-67_1>
<Element-380_1>4</Element-380_1>
<Element-67_2>006</Element-67_2>
<Element-380_2>16</Element-380_2>
<Element-67_3>007</Element-67_3>
<Element-380_3>4</Element-380_3>
<Element-67_4>008</Element-67_4>
<Element-380_4>5</Element-380_4>
<Element-67_5>009</Element-67_5>
<Element-380_5>3</Element-380_5>
<Element-67_6>010</Element-67_6>
<Element-380_6>2</Element-380_6>
<Element-67_7>011</Element-67_7>
<Element-380_7>5</Element-380_7>
<Element-67_8>012</Element-67_8>
<Element-380_8>7</Element-380_8>
<Element-67_9>014</Element-67_9>
<Element-380_9>2</Element-380_9>
</Segment-SDQ>
</Loop-ZA>
</Loop-LIN>
Following is my required output xml:
<Transaction-852>
<Record-Record1>
<Field-1>THD</Field-1>
<Field-2>20140105</Field-2>
<Field-3>001</Field-3>
<Field-4>722868102237</Field-4>
<Field-5>QS</Field-5>
<Field-6>008</Field-6>
<Field-7>1</Field-7>
</Record-Record1>
<Record-Record1>
<Field-1>THD</Field-1>
<Field-2>20140105</Field-2>
<Field-3>001</Field-3>
<Field-4>722868102237</Field-4>
<Field-5>QS</Field-5>
<Field-6>018</Field-6>
<Field-7>1</Field-7>
</Record-Record1>
<Record-Record1>
<Field-1>THD</Field-1>
<Field-2>20140105</Field-2>
<Field-3>001</Field-3>
<Field-4>722868102237</Field-4>
<Field-5>QS</Field-5>
<Field-6>027</Field-6>
<Field-7>1</Field-7>
</Record-Record1>
<Record-Record1>
<Field-1>THD</Field-1>
<Field-2>20140105</Field-2>
<Field-3>002</Field-3>
<Field-4>722868127469</Field-4>
<Field-5>QS</Field-5>
<Field-6>007</Field-6>
<Field-7>1</Field-7>
</Record-Record1>
<Record-Record1>
<Field-1>THD</Field-1>
<Field-2>20140105</Field-2>
<Field-3>002</Field-3>
<Field-4>722868127469</Field-4>
<Field-5>QS</Field-5>
<Field-6>010</Field-6>
<Field-7>1</Field-7>
</Record-Record1>
.
.
.
</Transaction-852>
Following is the output which I am getting now:
THD 20140105 001 722868102237 F2N036-06 008 1
THD 20140105 001 722868102237 F2N036-06 QS 018 1
THD 20140105 001 722868102237 F2N036-06 QS 027 1
THD 20140105 001 722868102237 F2N036-06 QS 044 -1
THD 20140105 001 722868102237 F2N036-06 007 1
THD 20140105 001 722868102237 F2N036-06 QS 010 1
THD 20140105 001 722868102237 F2N036-06 QS 017 1
THD 20140105 001 722868102237 F2N036-06 QS 020 1
THD 20140105 001 722868102237 F2N036-06 QS 021 1
THD 20140105 001 722868102237 F2N036-06 QS 022 1
THD 20140105 001 722868102237 F2N036-06 QS 025 1
THD 20140105 001 722868102237 F2N036-06 QS 028 2
THD 20140105 001 722868102237 F2N036-06 QS 048 1
THD 20140105 001 722868102237 F2N036-06 003 9
THD 20140105 001 722868102237 F2N036-06 QS 005 4
THD 20140105 001 722868102237 F2N036-06 QS 006 16
THD 20140105 001 722868102237 F2N036-06 QS 007 4
THD 20140105 001 722868102237 F2N036-06 QS 008 5
THD 20140105 001 722868102237 F2N036-06 QS 009 3
THD 20140105 001 722868102237 F2N036-06 QS 010 2
THD 20140105 001 722868102237 F2N036-06 QS 011 5
THD 20140105 001 722868102237 F2N036-06 QS 012 7
THD 20140105 001 722868102237 F2N036-06 QS 014 2
In the above output I am getting correct values for Field-6 and Field-7 of output xml but all the other Field values are remaining same not looping LIN and ZA values from Source xml