on 08-03-2007 8:01 AM
I have a requirement where i have two types 'A' and 'B'. On the target side i have 6 fields out of which 2 have to repeat for type 'A' and remaining 4 for type 'B'. I have to sort my records such that all type 'A' records come above and all type 'B' come below that.
I had written a UDF for that initially and even used sort by key. I got to know that i can duplicate subtree on the target side thus i can have one subtree for type 'A' and one for type 'B'.
If i get 10 records which can either 'A' or 'B' randomly arranged, how should i go with Duplicate Subtree for that. Please explain with a scenario.
Hi,
First in order to duplicate the node should have 1-unbounded occurences.
For duplicate right click the node and select duplicate.
Regards,
S.RamNarender
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jaya,
You just right click your node which you want to duplicate then you can choose the option Duplicate subtree. Now you mapped with you source element A twice and simlarly you just duplicate another type for 4 times and map with source element B.
Your problem will be solved.
Best Regards,
vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.