One method you could try would be using a table calculation
as described here:
Part 1 of calc:
IF FIRST()=0 THEN ATTR([Scheme])
which creates a running list.
This can be filtered down to just the last value using:
289572merge.twbx 14.4 KB