input_view.txt 337 B

123456789101112131415161718192021
  1. $p = @@
  2. def Parse(s):
  3. return {'subkey': s, 'value': s}
  4. @@;
  5. $pv = Python::Parse(Callable<(String)->Struct<subkey: String, value: String>>, $p);
  6. $i = (
  7. select
  8. AsStruct(key as key),
  9. $pv(info) as info
  10. from ViewSource
  11. where info != ""
  12. );
  13. $j = (
  14. select *
  15. from $i flatten columns
  16. );
  17. select * from $j