Skip to Content
0
Former Member
Apr 21, 2009 at 11:26 PM

Mapping Issue

16 Views

Hi all,

I have mapping issue...

My requirement is...

Source structure

Material Description  [0..unbound]	    	
            Type	    [1..1]                                            
            Desecration      [1..1]  	

Target Structure

Field1               [0..1]
      Description     [1..1]
            Value      [1..1]

Field2               [0..1]
       Desecration      [1..1]
            Value      [1..1]

From Source we are getting the 5 time

Type 1,2,3,4, and 5.

Description also we are getting respectively..

Means

type 1, Description A

type 2, Description B

type 3, Description C

type 4, Description D

type 5, Description E

If type = 1,2 and 3

Field1 - Description field we are sending constant value.

Value field - Type1 Description + Type2 Description + Type3 Description

If type = 4 and 5

Field2 - Description field we are sending constant value.

Value field - Type3 Description + Type4 Description

If not possible, Please give me the UDF code.

Thanks

SS