cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping to a lower hierarchy level in graphical mapping

0 Kudos

Hi All,

I am stuck where I need to map from a higher level to a lower hierarchy level in graphical mapping. Here is my scenario:

Source message Structure:

Header Rec 1

Item Rec 1_1

Item Rec 1_2

Item Rec 1_3

Header Rec 2

Item Rec 2_1

Item Rec 2_2

Item Rec 2_3

Source Sample file:

10, F1, F2

20, F3, F4

20, F5, F6

20, F7, F8

10, F9, F10

20, F11, F12

20, F13, F14

20, F15, F16

In the above sample file, 10 is the header record identified and 20 is item record identifier.

Required Taret message structure:

Header Rec 1[Item table - Item Rec 1_1

                     Item Table - Item Rec 1_2

                     Item Table - Item Rec 1_3]

Header Rec 2[Item table - Item Rec 2_1

                     Item Table - Item Rec 2_2

                     Item Table - Item Rec 2_3]

Item details are a table inserted in header record.

Required Target sample file:

10, F1, F2 [20, F3, F4

                 20, F5, F6

                 20, F7, F8]

10, F9, F10 [20, F11, F12

                   20, F13, F14

                   20, F15, F16]

When i map one to one (source header to target header, source detail to target detail), i am getting error - Can not create Header[2]/Item

I am playing around with SplitbyValue (each value) and MapwithDefault but nothing seems to work.

Thanks,

CS

Accepted Solutions (0)

Answers (2)

Answers (2)

RaghuVamseedhar
Active Contributor
0 Kudos

Chandra,

Please post screenshot mapping (source and target MT). Please attach xml coming to mapping.

former_member186851
Active Contributor
0 Kudos

Hello Chandra,

What is the occurence of the header field,

Try to sort the Source field and then try splitting

0 Kudos

Occurrences for both header and item are 1 to unbounded