Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
|
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 21st, 2009, 04:38 AM
Registered User
 
Join Date: Oct 2009
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Default 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
The Following User Says Thank You to stomar_3 For This Useful Post:





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in url mapping deepikachitturi Visual Studio 2008 0 January 29th, 2009 01:25 AM
Problem with dateField while Mapping mamatharocks Biztalk 0 September 18th, 2008 11:25 PM
MapForce mapping problem blackest XSLT 2 March 19th, 2008 10:34 AM
O/R mapping s_sana General .NET 0 April 12th, 2005 06:34 AM
DTS Column Mapping Problem hortoristic SQL Server 2000 2 August 2nd, 2004 03:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.