Re: sorting and merging in perl

[Anonymous Monk]

How are you failing?

[Sekhar Reddy]

Thank you everyone, i some how able to solve this.

I did it by finding the count of unique A1's and i stored it in hash as a key, A loop to iterate that many number of times to create a new hash which store the A1 and activedate as a key.

Sort by active date

find the consecutive rows by having a count(unique A1 and B1).