cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping problem

Former Member
0 Kudos
65

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....

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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