JOIN_ALL_BY_KEY
Combines multiple key value arrays into one by the keys.
Syntax
Arguments
Examples
Transformation job example
SQL
Query result
Last updated
Name | Type | Description | Default Value |
---|---|---|---|
fieldNames | inputs1 | inputs2 | inputs3 | inputs4 | inputs5 | inputs6 | Output |
---|---|---|---|---|---|---|---|
fieldNames | inputs1[] | inputs2[] | inputs3[] | inputs4[] | inputs5[] | inputs6[] | Output |
---|---|---|---|---|---|---|---|
fieldNames
string
Optional comma separated field names
""
inputs#
any
'first,second,third'
array['a', 'b', 'c']
array[1, 2, 3]
array['b', 'd', 'a']
array[2, 4, 1]
array['c', 'b']
array[false, true]
[{key: a
, first: 1, second: 1, third: null}, {key: b
, first: 2, second: 2, third: true}, {key: c
, first: 3, second: null, third: false}, {key: d
, first: null, second: 4, third: null}]
'first,second,third'
array['a', 'b', 'c']
array[1, 2, 3]
array['b', 'd', 'a']
array[2, 4, 1]
array['c', 'b']
array[false, true]
[{key: a
, first: 1, second: 1, third: null}, {key: b
, first: 2, second: 2, third: true}, {key: c
, first: 3, second: null, third: false}, {key: d
, first: null, second: 4, third: null}]