1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
$f = ($key, $leftList, $rightList) -> {return <|k:$key, v:ListZipAll($leftList, $rightList)|>;};
$a = [
<|key: 1, subkey: 11, value: "111"|>,
<|key: 1, subkey: 12, value: "112"|>,
<|key: 2, subkey: 21, value: "221"|>,
<|key: 2, subkey: 22, value: "222"|>,
<|key: 3, subkey: 33, value: "333"|>,
];
$b = [
<|key: 1, subkey: 11, value: "111"|>,
<|key: 2, subkey: 22, value: "222"|>,
<|key: 3, subkey: 33, value: "333"|>,
<|key: 4, subkey: 44, value: "444"|>,
<|key: 5, subkey: 55, value: "555"|>,
];
COMBINE AS_TABLE($a) as A
WITH AS_TABLE($b) as B
PRESORT B.key, B.subkey
ON A.key = B.key
USING $f(TableRow(), TableRow())
|
