| Teddy B 2006-03-21, 8:02 am |
| Hi, I have been trying to resolve the problem I am having but I really
don't know if it is even possible using biztalk? Can anyone give me any
advice, because it is desperately needed?
My previous post was:
-----------------------------------------------------------
I am having problems trying to map together two XML files using
Biztalk 2002. Can any one help me out?
The problem is:
Each order line in the input file needs to be mapped to two order
lines in the output file. Each order line in the output file is exactly
the same structure but is distinguished by being a different condition
(The first condition = 01, and the second = 02).
To explain more clearly, the inbound document is as follows:
<Orderline>
<CustomerProductRef></CustomerProductRef>
<ProductRef>1000080436</ProductRef>
<Quantity>90</Quantity>
<Price>6412.21</Price>
<EnergySurcharge>900.0</EnergySurcharge>
<Width>3210</Width>
<Lenght>6000</Lenght>
The outbound document needs to read:
<OutboundOrderLine>
<ITM_NUMBER>00010</ITM_NUMBER>
<COND_ST_NO>001</COND_ST_NO>
<COND_COUNT>01</COND_COUNT>
<COND_TYPE>PB00</COND_TYPE>
<COND_VALUE>6412.21</COND_VALUE>
<OutboundOrderLine>
<ITM_NUMBER>00010</ITM_NUMBER>
<COND_ST_NO>001</COND_ST_NO>
<COND_COUNT>02</COND_COUNT>
<COND_TYPE>ZS00</COND_TYPE>
<COND_VALUE>900.0</COND_VALUE>
The problem would be very simple to solve if I was allowed to add an
extra order line record (e.g. <OutboundOrderLineCondtion2> ) but I do
not have this luxury. I can only have the one record called
<OutboundOrderLine>.
I have no experience with setting XML conditions, so I am at a dead
end. I am sure the answer lies with the looping functoid, but how I do
not know.
Many thanks in advance for any help anyone can provide.
|