Skip to Content
author's profile photo Former Member
Former Member

Mapping to a lower hierarchy level in graphical mapping

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 12, 2015 at 11:12 AM

    Hello Chandra,

    What is the occurence of the header field,

    Try to sort the Source field and then try splitting

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2015 at 02:53 PM

    Chandra,

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.