locked
Flat file Schema selecting only alternate records RRS feed

  • Question

  • Hi, I have created a Flat file schema using the FF wizard. The structure of schema is:

    <Schema>
              <Parent>
                     <Records>


    Id1,text1,text1,text1{cr}{lf}
    Id2,text1,text1,text1{cr}{lf}
    Id3,text1,text1,text1{cr}{lf}
    Id4,text1,text1,text1{cr}{lf} and so on

    However, when I tried validate the instance in VS, it excludes alternate records and gives output as Validation succeeded.
    I have given Child delimiter as "0x0D 0x0A"  and Order as "Postfix" at Parent node and Child delimiter as ","  and Order as "Infix" at Records node. If you have come across <g class="gr_ gr_324 gr-alert gr_gramm gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="324" id="324">similar</g> issue, please let me know how was it resolved it.

    Monday, February 13, 2017 6:12 AM

Answers

  • The sample file that I was testing against was the culprit here. There was nothing wrong with the schema.
    Monday, February 13, 2017 11:57 PM

All replies

  • My advice is to run the Flat File Schema Wizard again, and again, until you get it right.

    There's nothing wrong with that.

    Monday, February 13, 2017 1:17 PM
    Moderator
  • The sample file that I was testing against was the culprit here. There was nothing wrong with the schema.
    Monday, February 13, 2017 11:57 PM