if_struct.sql 273 B

1234
  1. insert into plato.Output
  2. select * from (select IF(key == "foo", CombineMembers(RemoveMembers(LAG(data) OVER w, ["key"]), ChooseMembers(data, ["key"])), data) from
  3. (select TableRow() as data, key, value from plato.Input)
  4. window w as (partition by key)) flatten columns;