Re: Table column vales to JSON object keys?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thursday, February 11, 2021, Wells Oliver <wells.oliver@xxxxxxxxx> wrote:

Trying to go from a table like:

 g  | e |  angle | path
----+---+--------+----------------------
 g1 | e1 | a1    | http://foo.com/a.mp4
 g1 | e1 | a2    | http://foo.com/b.mp4
 g1 | e1 | a3    | http://foo.com/c.mp4

To a table like this, with a column value per angle as a key.

 g  | e |  obj
----+---+---------------------------------------------------------------------------------------------
 g1 | e1 | {"a1": "http://foo.com/a.mp4", "a2": "http://foo.com/b.mp4", "a3": "http://foo.com/c.mp4"}
 

Can't quite get there.

How far can you get?

David J.