on 03-14-2008 4:07 AM
In the soure we have a structure like George, peter, john, George,peter and at the target side I want each field
appear once like George, peter, john. How to achieve this?
Hi,
As per your info..the Occurance of source side is more tan 1 ie.e Unbounded
Make the occurance on receiver side as 1, it wil give you only one value as George, peter, john
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suresh,
You can give the logic as raj suggestion for source your source and target .(or ) I hope according to your requirement graphical mapping is enough mapping source and target fields.
Any clarifacations please reply.
Regards
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
if u want the each field at the target side only once just put the occurence for each filed as 1..1or 0..1 .
then it willl come only once.
if u still face the problem please reply me back.
Thanks
Rinku
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Suresh,
Let me clear with some example
Source
<Record>
<name/>0..unbounded
</Record>
Target
<Record>
<name/>0..unbounded
</Record>
Now you have
<Record>
<name>George</name>
<name>Peter</name>
<name>John</name>
<name>George</name>
<name>Peter</name>
</Record>
You want the out put as
<Record>
<name>George</name>
<name>John</name>
<name>Peter</name>
</Record>
Correct?
Follow the logic:
name[change context]------->Sort------>SplitByValue[Value Changed]-------->CollapseContext------->name
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
in source u map with George, peter, john to target George, peter, john.
then u r porblem will solve..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.