New Flat File Wizard problems

I was assigned to build some flat file maps for some drug data. This was a positional file with carriage return and line feed at the end of each record.

I opened the flat file wizard and generated my positional file that looked like this:

Header1 Required

Header2 Required

Detail1 Optional

Detail2 Optional

Detail3 Optional

Trailer Required

After entering the format I had 3 problems

1. It should look like this:

Header1

Header2

Body

Detail1

Detail2

Detail3

Trailer

The body data is repeating.

2. On the schema node there is a property:

Parser Optimization

This needs to be changed from "speed" to "complex". It will not work with out this be set to "complex".

3. The min and max for each record needs to be as follows

MAX MIN

Header1 1 1

Header2 1 1

Body Unbounded 0

Detail1 Unbounded 1

Detail2 Unbounded 0

Detail3 Unbounded 0

Trailer 1 1

Do not let the min and max default!!! Blank does not mean zero. Put the zero in the minimum or you will have troubles. The record will still be required. Blank means 1.(I think)

Good luck, Let me know if you find other issues?