Problem facing with flat file schema

, ,
1

Hi Everyone,

We are facing problem with flat file schema for the following data.Here both the header and detail have to defined as recordWithNoID. In this case Header and Detail records both are repeating.Please advise how to distinguish between header and detail.

1;1;;SA;X101;20090131;1;20090131;GBP;REFERENCE;TEXT(*Header Level 1)
1;1;;40;41120000;;9000;;A0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;X101001(*Lilne Item1)
1;2;;50;10200200;;9000(*Lilne Item2)
2;1;;SA;X101;20090131;1;20090131;GBP;REFERENCE;TEXT(*Header Level 2)
2;1;;40;41120000;;9000;;A0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;X101001(*Lilne Item1)
2;2;;50;10200200;;9000(*Lilne Item2)

Thanks in advance…

Regards,
Renuka

2

Hi

Consider this .Say your header is h1 and line items are L1,L2…

And this is your file

h1
L1
L2
h2
L1
L2
.
.

How i do this is

i will define a new dictionary .In the dictionary i define two records H(H represents h1,h2 records and L(represents L1,L2…).And these records will be recordid= recordWithNoID.
And next i create a flatfile schema import the dictionary records into it and in the schema i arrange the records like this (tree structure)

H (unlimited)

  • L(unlimited)

We can also do this directly by defining a ffschema without defining a dict.This is very simple and it should work .Please let me know if you have any probs

thanks
Anil