I seem to be unable to come up with a reasonably elegant solution to a seemingly trivial challenge.
I have view A delivering the following:
Vehicle Owner Driver Miles
ABC123 Otto - 1000
ABC123 - Ravi 1000
XYZ345 Jose - 500
XYZ345 - Meret 500
Where 'Vehicle' is the logical key
The requirement is to use view A as input and end up with this:
Vehicle Owner Driver Miles
ABC123 Otto Ravi 1000
XYZ345 Jose Meret 500
Very simple right? Well I know how I could code this out with SQL in a Script Calc View or use if ... else's, but figuered there must be a more elegant possibility.
Any suggestions out there? Thanx.