on 06-16-2015 7:38 AM
Hi All,
I have a requirement where I need to pick the latest values from multiple records based on rundate.
The I/P is like this :
<Message>
<ID>1234</ID>
<Name>Raj</Name>
<Name_Date>20150512</Name_Date>\
<SSN>1298</SSN>
<SSN_Date>20150618</SSN_Date>
</Message>
..
<Message>
<ID>1234</ID>
<Name>Ajay</Name>
<Name_Date>20150516</Name_Date>
<SSN>2156</SSN>
<SSN_Date>20150614</SSN_Date>
</Message>
The Output should be:
<Message>
<ID>1234</ID>
<Name>Ajay</Name>
<Name_Date>20150516</Name_Date>\
<SSN>1298</SSN>
<SSN_Date>20150618</SSN_Date>
</Message>
So the logic is that the value of the field should be closest to the RunDate(current date).
Please let me know your feedback on how this requirement can be achieved ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Arijit,
You could solve this quite easily with grafical mapping:
Use SortByKey for the root node and use SSN_Date as key.
Map all other fields 1:1.
If your target node has the occurency 1...1 or 0...1, it will only be created once.
best regards,
Heiko
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.