BizTalk Mapping: One input to two outputs with a condition

• Question

• 

  

  0

  Sign in to vote

  I'm having a real challenge with this one. I receive a flat file with around 50 records. From each record I need to create 1 or 2 outputs. The 2^nd output is conditional.

  The output is:

  <schema>

              <WebServiceName>

                          <Line>

                                      <Amount>

                                      <ClaimReference>

                                      <StartDate>

                                      <EndDate>

                                      <PaymentNote>

  The input is:   

  <schema>

              <FF>

                          <Record>

                                      <ClaimReference>

  <TransactionAmount>

                                      <TransactionStartDate>

                                      <TransactionEndDate>

                                      <PaymentNote>

  <AdjustmentAmount>

                                      <AdjustmentStartDate>

                                      <AdjustmentEndDate> 

  I need the transaction & adjustment going out on their own with payment note & claim ref the same for both.

  The conditional is not all records have the adjustment data. The fields come populated with '?' rather than being null or empty strings.

  I've tried a number of different methods mainly using Looping Tables (below) but I keep having the same 2 recurring problems.

  The condition I have been attempting, is if the 'AdjustmentStartDate' field does/doesn't contain '?'. When I create a condition not to send data to the output node I get an error as nothing was passed in (node was expecting data). It is expecting data because of the connection to the Looping Table. The map will error if that connection is not there.

  Any method I've attempted without using the Looping Tables hasn't worked because the output doesn't expect to create 2 separate xml outputs from 1 input record. 

  I would really appreciate some help with this one!

  Thursday, September 3, 2020 12:38 PM