Defining Flat File schema, with record type in random positions

, ,
1

Hello Friends

I need advise in defining a complicated flat file schema. The file is data positioned file. Below is how it looks in hierarchy. There are 2 types of records one with 0100 & 0200. There are additional records under each type.

0010 [Transmission header]…Data

0100 {Type 1]…Data
0105
0110
0199
0200 [Type 2]…Data
0205
0210
0230
0235
0299

9999 [Transmission Detail]

My problem is the sequence or 0100 & 0200 type is random. In some files 0200 set comes first & 0100 & again 0200 …etc.
Any idea how to handle it? I tried with floating record, but it allows only one type. The detail record like 0105 etc, cannot be defined then.I have attached a dummy sample file.

The only option i see is to define only one schema per type and processing the file twice per type.I was looking for a better option.

Thanks
Anish.

Samplefile.txt (5.03 KB)

2

Hi Anish ,

Have you set the property of the Flat File Schema as Ordered to “False” ?

Please set it to False. It will then handle the 0100 & 0200 records even if they are not in any predefined order.

3

Hello Rakesh

I tried it and the 0100 series went under 0200. I have attached the screen shot with the results

Thanks
Anish
Screen_Shot.docx (128 KB)