Filter data list

[gidon500]

Hi All

enclosed if file

ORD is order no number .

key line no

I have a list of orders , the orders status  change one a while 

i need to create for every order  = ORD

the first key  for ORDTATUS = '-1'  this is the creation of the order

and the last key for ORDTATUS = '-4' this us the close of the order

there are many orders without close line  .

thaks

gidon

[gidon500]

hi  to clarify

the output should be for every order

max 2 line

the creation line

and the close line if order closed

thanks

gidon

[salto · Accepted solution]

Maybe this piece of code could do the job.

Regards.

[gidon500]

Hi salto

thank you very much

gidon