ExtendAndTake.sql 244 B

12345678910
  1. /* syntax version 1 */
  2. $split = ($row) -> {
  3. return String::SplitToList($row.value, " ", true AS SkipEmpty, false AS DelimeterString);
  4. };
  5. SELECT
  6. $split(TableRow()),
  7. ListExtend($split(TableRow()), $split(TableRow()))[1]
  8. FROM Input;