Problem with advanced mapping
Dear Collegs,
I have one issue and hope that you can help me. Namely, I have a problem with advanced mapping between two schemas.
This are two schemas between which I must good mapping make.
The problem is in HeaderNotes. Namely, I want mapping which works on this princips :
1. If field ExtraNotesHeader1 has a some value than in destination schema in HeaderNotes\Desctiption transfer that value and the value in ID field automaticly set to ENH1
2. If field ExtraNotesHeader2 has a some value than in destination schema in HeaderNotes\Desctiption transfer that value and the value in ID field automaticly set to ENH2
3. If field ExtraNotesHeader3 has a some value than in destination schema in HeaderNotes\Desctiption transfer that value and the value in ID field automaticly set to ENH3
4. If all fields are empty than do not create anything in HeaderNotes.
SOURCHE SCHEMA
<Orders> <Order> <OrderNumber>
<Customer Number>
<ShipDate>
<DeliveryDate>
<Adress>
<ZipCode>
<Town>
<ItemNo>
<Quantity>
<Amount>
<Status>
<ShipmentMethod>
<PaymentMethod>
<ExtraHeaderNotes1>
<ExtraHeaderNotes2>
<ExtraHeaderNotes3>
DESTINATION SCHEMA
<Order>
<OrderHeader>
<Customer>
<ShipDate>
<DeliveryDate>
<Adress>
<ZipCode>
<Town>
<Status>
<OrderLine>
<LineNumber>
<ItemNo>
<Amount>
<Quantity>
<HeaderNotes>
<ID>
<Desctiption>
THANKS IN ADVANCE
|