Originally posted by: paul.brett

A client had a requirement to group based on subsequent records:

Input:

DT1 Record  -                           Amount 20 | Reference ABC
DT2 Record  -                           Amount 00 | Reference DEF
DT3 Record  -                           Amount 00 | Reference GHI
DT4 Record  -                           Amount 30 | Reference JKL
DT5 Record  -                           Amount 00 | Reference MNO

Output required:

DT1 Record  -                           Amount 20 | Reference ABC|Reference DEF|Reference GHI
DT4 Record  -                           Amount 30 | Reference JKL|Reference MNO

Grouping needs to be decided based on future records.

This is my solution, let me know if you have alternatives.

Thank-you

Paul

Follow me on Twitter

Originally posted by: DeM0n

I provided this example....

Attachment(s)

Test.zip   1 KB 1 version

Originally posted by: paul.brett

Another very good solution.  Nice!

Thank-you

Paul

Follow me on Twitter