08-23-2013 04:38 PM
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.
08-23-2013 05:33 PM
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.