on 12-23-2011 9:51 AM
Hi,
My scenario is file-Idoc and I created everything in ESR and id part and configuration steps but struck in mapping level.
Source Structure(example):
Fields order:
u2026. . name id u2026u2026u2026
u2026.. a 10000 u2026u2026.
u2026.. b 10001 u2026u2026.
u2026.. c 10000 u2026u2026.
u2026.. d 10002 u2026u2026.
u2026.. e 10002 u2026u2026.
u2026.. f 10002 u2026u2026.
u2026.. g 10001 u2026u2026.
Target structure:
I need to create below like this.
fieldsu2026u2026u2026u2026.
10000
a
c
u2026u2026u2026u2026u2026u2026u2026.
u2026u2026u2026u2026
10001
b
g
u2026u2026u2026u2026u2026
u2026u2026u2026u2026u2026..
10002
d
e
f
u2026u2026u2026u2026u2026u2026u2026u2026.
Could you please tell me how to map the fields?
thanks
roopa....
Roopa,
The solution proposed by Bhavani needs to be corrected in one place else its proper to produce your desired result in the target. Here is where the logic should be changed...
Step 1 : id-> remove context -> sort (in properties select Numerical)-> split by value (value change) -> Collapse context ->split by value (each value) -> id
Step 2: name -> remove context -> sortbyKey(1st input should be id - > remove context and 2nd input should be name - > remove context)-> formatByExample(with second input as same mapping of id in step 1 upto split by value(value change)) ->splitByValue(each value) name
As name can be anything and also it should be correlated to corresponding id so that you put in the sequence as you create the id on the target
let us know if this works !!
Thanks,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Source Structure(example):
Fields order:
u2026. . name id u2026u2026u2026
u2026.. a 10000 u2026u2026.
u2026.. b 10001 u2026u2026.
u2026.. c 10000 u2026u2026.
u2026.. d 10002 u2026u2026.
u2026.. e 10002 u2026u2026.
u2026.. f 10002 u2026u2026.
u2026.. g 10001 u2026u2026.
Target structure:
I need to create below like this.
fieldsu2026u2026u2026u2026.
10000
a
c
u2026u2026u2026u2026u2026u2026u2026.
u2026u2026u2026u2026
10001
b
g
u2026u2026u2026u2026u2026
u2026u2026u2026u2026u2026..
10002
d
e
f
u2026u2026u2026u2026u2026u2026u2026u2026.
That is simple by using splitByValue.
Please try below logic:
id-> remove context -> sort-> split by value (value change) -> Collapse context ->split by value (each value) -> id
name -> remove context -> sort by key -> formatbyexample ->split by value (each value) -> name
thanks,
Edited by: bhavanisankar.solasu on Dec 23, 2011 12:33 PM
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 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.