Re: Table column vales to JSON object keys?

On Thursday, February 11, 2021, Wells Oliver <wells(dot)oliver(at)gmail(dot)com> 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.