Nested Loop for EDI 810

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Nested Loop for EDI 810

Viewing 0 reply threads
  • Author
    Posts
    • October 30, 2013 at 4:30 PM #26190
      community-content
        Hi,
        I am having an output requirement like this: where N1 Loop where N10= RI (remit Info) needs to have two REF_2 loops with Account info & Routing info as here.  Other N1 Loops like SO (sellt- Info) do not need that.
        – <ns0:N1Loop1>
        – <ns0:N1>
          <N101>SO</N101>
          <N102>Customer Name</N102>
          </ns0:N1>
          </ns0:N1Loop1>
        – <ns0:N1Loop1>
        – <ns0:N1>
          <N101>RI</N101>
          <N102>Vendor Name</N102>
          </ns0:N1>
        – <ns0:REF_2>
          <REF01>AP</REF01>
          <REF02>12345678</REF02>
          </ns0:REF_2>
        – <ns0:REF_2>
          <REF01>RT</REF01>
          <REF02>987654321</REF02>
          </ns0:REF_2>
          </ns0:N1Loop1>
         
        I have a map like this, where N1 loops containing SO  & RI  are created by TableLooping.  For the REF_2 loops i want to use another table Loop as shown here having a scope of RI.
         
        However the best i can get is this: where REF_02 gets the AP & RI info in all N1 loops.  I tried several ways to suppress creation of REF_2 for N1 loop for SO; but it didnt help.  Is there a way to do that?

        – <ns0:N1Loop1>
        – <ns0:N1>
          <N101>SO</N101>
          <N102>Customer Name</N102>
          </ns0:N1>
        – <ns0:REF_2>
          <REF01>AP</REF01>
          <REF02>12345678</REF02>
          </ns0:REF_2>
        – <ns0:REF_2>
          <REF01>RT</REF01>
          <REF02>987654321</REF02>
          </ns0:REF_2>
          </ns0:N1Loop1>
        – <ns0:N1Loop1>
        – <ns0:N1>
          <N101>RI</N101>
          <N102>Vendor Name</N102>
          </ns0:N1>
        – <ns0:REF_2>
          <REF01>AP</REF01>
          <REF02>12345678</REF02>
          </ns0:REF_2>
        – <ns0:REF_2>
          <REF01>RT</REF01>
          <REF02>987654321</REF02>
          </ns0:REF_2>
          </ns0:N1Loop1>
         
        Thanks,
         
        Amol

    • Author
      Posts
    Viewing 0 reply threads
    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.