on 07-17-2015 3:38 PM
Hello Friends,
I want to delete duplicate node using XSLT mapping . For example in the source xml multiple Expences node are there so In case of multiple Expenses node with similar content like 1st and 3rd Expenses node in input XML . In that case from output xml should display only first and second Expenses node.
Input XML
-----------------
<?xml version="1.0"?>
<Root>
<Expenses id="dtmId001">
<Expense>
<seqnr>34</seqnr>
<key>109</report_key>
</Expense>
<Expense>
<seqnr>35</seqnr>
<key>110</report_key>
</Expense>
</Expenses>
<Expenses id="dtmId002">
<Expense>
<seqnr>54</seqnr>
<key>112</report_key>
</Expense>
</Expenses>
<Expenses id="dtmId003">
<Expense>
<seqnr>34</seqnr>
<key>109</report_key>
</Expense>
<Expense>
<seqnr>35</seqnr>
<key>109</report_key>
</Expense>
</Expenses>
</Root>
Expected XML output
----------------------------------------
<?xml version="1.0"?>
<Root>
<Expenses id="dtmId001">
<Expense>
<seqnr>34</seqnr>
<key>109</report_key>
</Expense>
<Expense>
<seqnr>35</seqnr>
<key>110</report_key>
</Expense>
</Expenses>
<Expenses id="dtmId002">
<Expense>
<seqnr>54</seqnr>
<key>112</report_key>
</Expense>
</Expenses>
</Root>
Sarojkanta,
XSLT 2.0 can handle duplicates easily.
Removing duplicates in xml with xslt - Stack Overflow
FYI.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sarojkanta,
Not sure, what exactly is your requirement.
In case you just need this unique object. You can try below graphical mapping.
Expense ->remove context -> Split by value (Value change) -> collapse context
Regards,
Sachin Dhingra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.