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