Dropping Records into 'Buckets'

Occasional Contributor
Posts: 6

Dropping Records into 'Buckets'

I have a transaction file that cuts a record for each date a transaction is updated.  I never know how many times a transaction will be updated before it is closed, therefore I never know how many records there will be.  I would like to take that transaction ID and cut one record that contains the multiple dates along with some other key columns.  I know it will be uhly with some of the 'date buckets' containing blanks, but this is how the user wants the data displayed.  I'd appreciate suggestions. 

Super User
Posts: 13,583

Re: Dropping Records into 'Buckets'

A little clearer description of your current data structure and desired output will be helpful, otherwise we're going to make lots of assumptions/guesses. Best would be some dummy data and the desired output.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation