on 10-12-2015 11:44 AM
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
Chandra,
Please post screenshot mapping (source and target MT). Please attach xml coming to mapping.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Chandra,
What is the occurence of the header field,
Try to sort the Source field and then try splitting
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.