Skip to Content
0
Former Member
Aug 03, 2016 at 01:20 PM

Make One Row Out of Two Rows

40 Views

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.