XML Output stage repetitive data elements issue
Posted: Tue Feb 17, 2015 3:43 pm
Hello All,
I have below values in the source:
COL-A COL-B
2810945 S
2810965 S
2810985 S
4025390 H
4041510 B
4041512 B
I am expecting below XML structure
But I am getting below result:
I used below XPATH to generate the data element structure:
COLUMN_CODE ==> /s:LineItems/s:Code
COLUMN_CODEVALUE ==> /s:LineItems/s:Values/s:CodeValue
I tried multiple options but could not generate the expected XML structure. Can you please let me know the process/option to accomplish the desired result?
Thanks in advance!
-Amit
I have below values in the source:
COL-A COL-B
2810945 S
2810965 S
2810985 S
4025390 H
4041510 B
4041512 B
I am expecting below XML structure
Code: Select all
<s:LineItems>
<s:Code>2810945</s:Code>
<s:Values>
<s:CodeValue>S</s:CodeValue>
</s:Values>
</s:LineItems>
<s:LineItems>
<s:Code>2810965</s:Code>
<s:Values>
<s:CodeValue>S</s:CodeValue>
</s:Values>
</s:LineItems>
<s:LineItems>
<s:Code>2810985</s:Code>
<s:Values>
<s:CodeValue>S</s:CodeValue>
</s:Values>
</s:LineItems>
<s:LineItems>
<s:Code>4025390</s:Code>
<s:Values>
<s:CodeValue>H</s:CodeValue>
</s:Values>
</s:LineItems>
<s:LineItems>
<s:Code>4041510</s:Code>
<s:Values>
<s:CodeValue>B</s:CodeValue>
</s:Values>
</s:LineItems>
<s:LineItems>
<s:Code>4041512</s:Code>
<s:Values>
<s:CodeValue>B</s:CodeValue>
</s:Values>
</s:LineItems>
Code: Select all
<s:LineItems>
<s:Code>2810945</s:Code>
<s:Code>2810965</s:Code>
<s:Code>2810985</s:Code>
<s:Values>
<s:CodeValue>S</s:CodeValue>
</s:Values>
</s:LineItems>
<s:LineItems>
<s:Code>4025390</s:Code>
<s:Values>
<s:CodeValue>H</s:CodeValue>
</s:Values>
</s:LineItems>
<s:LineItems>
<s:Code>4041510</s:Code>
<s:Code>4041512</s:Code>
<s:Values>
<s:CodeValue>B</s:CodeValue>
</s:Values>
</s:LineItems>
COLUMN_CODE ==> /s:LineItems/s:Code
COLUMN_CODEVALUE ==> /s:LineItems/s:Values/s:CodeValue
I tried multiple options but could not generate the expected XML structure. Can you please let me know the process/option to accomplish the desired result?
Thanks in advance!
-Amit