Requirement: To map child level field in a nested structure in AIF.
Source field: StreetPostalCode --> (/Supplier/AddressInformation/Address/PhysicalAddress/StreetPostalCode)
Target field: RegionName --> (/Supplier/AddressInformation/Address/PhysicalAddress/RegionName)
Solution:
Step 1: Root level structure mapping.
Assign "Supplier" as the source and target structure.
The next segment in the target structure after Supplier is "AddressInformation".
So, select "AddressInformation" as the field in destination structure and assign it as a Sub-Table as well.
Step 2: First level structure mapping.
Assign "AddressInformation" as the source and target structure. This time "Indirect Mapping" checkbox is selected as well.
The next segment in the target structure after AddressInformation is "Address".
So, select "Address" as the field in destination structure and assign it as a Sub-Table as well.
Step 3: Second level structure mapping.
Assign "Address" as source and target structure. This time as well "Indirect Mapping" checkbox is selected.
The next segment in the target structure after Address is "PhysicalAddress".
So, select PhysicalAddress as the field in destination structure and assign it as a Sub-Table as well.
Step 4: Third level structure mapping.
Assign "PhysicalAddress" as the source and target structure. This time as well "Indirect Mapping" checkbox is selected.
Map the target field "RegionName" with the source field "StreetPostalCode".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |