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
Combines multiple key value arrays into one by the keys
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}]