Using a map to turn a Flatfile schema into hierachical one

Home Page Forums BizTalk 2004 – BizTalk 2010 Using a map to turn a Flatfile schema into hierachical one

Viewing 1 reply thread
  • Author
    Posts
    • #21918

      I am trying to create a map to convert a file consisting of just order lines into one with a order, order line hierarchy.  e.g.

      Order1, Line1
      Order1, Line2
      Order2, Line3
      Order3, Line4

      into…

      <Order>
         <OrderName>Order1</OrderName>
         <OrderLine>Line1</OrderLine>
         <OrderLine>Line2</OrderLine> 
      </Order>
      <Order>
         <OrderName>Order2</OrderName>
         <OrderLine>Line3</OrderLine>
      </Order>
      <Order>
         <OrderName>Order3</OrderName>
         <OrderLine>Line4</OrderLine>
      </Order> 

      I thought that this should be a simple task but…  

      • If I just map one record format to the other then I get an <Order> node for each line on the input file.  
      • However if I use a Looping functiod with a logical operator to suppress the creation of the <Order> node for the second line of the input file, it also suppress the creation of the <OrderLine> node.

      Can anyone give me some pointers to what I should be doing?

      Many thanks,

      Neil

    • #21920
Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.