Skip to Content
0
Jan 06, 2011 at 02:05 PM

File sequence number in a Flat file

19 Views

Hi,

I am working on Idoc to file scenario wherein my output file will have a sequence number assigned to each level.

there are 4 levels and hence 4 sequence number to be genearted and its values should also have the same sequence number.

i am doing this just by using Counter function.

But when i am getting a multiple detail records, for each detail record(0040) level its keep incrementing.but it should have the same value what its level has.

for ex:

ALPHAMER AS2 E5 710 20114806124829 01.00

0000 00000000 20100102 V3.0 SORD CZ1

0010 00000001 76767 123 100 WER Constant BNG 560011 RAJ WERR 560011 BTM X EN RT

0020 00000001 TYUIOP

0040 00000001 8765 6532 200 45 10 WE 20 AG

0040 00000002 8765 6532 200 45 10 WE 20 AG

0040 00000003 8765 6532 200 45 10 WE 20 AG

0040 00000004 8765 6532 200 45 10 WE 20 AG

9999 99999999

It has to be like this.

ALPHAMER AS2 E5 710 20114806124829 01.00

0000 00000000 20100102 V3.0 SORD CZ1

0010 00000001 76767 123 100 WER Constant BNG 560011 RAJ WERR 560011 BTM X EN RT

0020 00000001 TYUIOP

0040 00000001 8765 6532 200 45 10 WE 20 AG

0040 00000001 8765 6532 200 45 10 WE 20 AG

0040 00000001 8765 6532 200 45 10 WE 20 AG

0040 00000001 8765 6532 200 45 10 WE 20 AG

9999 99999999

Can someone help me in achieving this.

Regards