Create Flat File Schema

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Create Flat File Schema

Viewing 1 reply thread
  • Author
    Posts
    • October 27, 2006 at 4:53 AM #16223
      community-content

        I'm trying to create a schema for the following sample flat file:

        10K01006K1120120  00026605666520     
        40003010        U11568   652000A330  
        10K01006K3010526  00026633158480     
        40008420        U10926   1602        
        40003010        U10926   848000U130  

        where each row starting with "10" is the parent for each following row starting with "40".

        So for each "10"-row there can be multiple "40"-rows. Each line ends with CR/LF and this row fields are "relative position".

        Is this possible to create?

      • October 27, 2006 at 5:32 AM #16224
        community-content

          The above schema design is absolutely possible use Flat -File shema wizard for this schema design.

           

           

          • October 30, 2006 at 2:28 AM #16246
            community-content

              [quote user="Anonymous"]

              The above schema design is absolutely possible use Flat -File shema wizard for this schema design.

              [/quote]

              How? 🙂

              • October 30, 2006 at 3:08 AM #16247
                community-content

                  You could just add a FlatFile schema with this structure

                  Root (delimited PostFix Hex 0x0D 0x0A)
                  –Document (delimited InFix Hex 0x0D 0x0A maxOccurs=unbounded)
                  —-Header (Positional, Tag Identifier=10)
                  ——You header elements here
                  —-Items(delimited InFix Hex 0x0D 0x0A)
                  ——Item(Positional, Tag Identifier=40 maxOccurs=unbounded)
                  ——–your item elements here

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