Flat file mapping

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Flat file mapping

Viewing 1 reply thread
  • Author
    Posts
    • October 30, 2008 at 9:34 AM #21094
      community-content

        I need to map this flat file format:
        1-Origin12356789
        2-customer line 1
        3-customer line 2
        4-Order line 1
        5-order line 2
        6-items (multiple)

        2-6 are repeated (multiple orders)
        I tried disassembling in a pipeline with envelope being 1 to split to multiple files.  I can make it work with 3 levels (like with line 1,2,6).

        1-Origin12356789
        2-customer line 1
        6-items (multiple)
        2-customer line 1
        6-items (multiple)
        …

        Any ideas? [:@]

      • October 30, 2008 at 9:54 AM #21095
        community-content

           I should add that it goes to the end of the file looking for ‘
          ‘ .  I tried everything (hopefully not) I can set with my schema.  Anyone wants to give this a try?  Thanks for your help.

          0    3395081014                              CMD_081014_3ATQBOV023                      
          1CUSTOMER INFORMATION 1                                                                        
          1CUSTOMER INFORMATION 2    
          2ORDER INFO 1
          2ORDER INFO 2
          4ITEM
          4ITEM  (ANY NUMBER OF THIS)
          1CUSTOMER INFORMATION 1                                                                        
          1CUSTOMER INFORMATION 2    
          2ORDER INFO 1
          2ORDER INFO 2
          4ITEM
          …

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