Join By Key Node

J

Utils/Array

Matches the elements of two arrays on a shared key, the way a database join does

array_join_bystd

Inputs5

Outputs2

Security exposure10/10

Packagestd

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

SecurityAttack surface and exposure impact.

10/10High

PrivacyPotential sensitivity of processed data.

10/10High

PerformanceRuntime or resource pressure.

10/10High

GovernancePolicy, audit, or compliance impact.

10/10High

ReliabilityOperational stability considerations.

10/10High

CostExternal or compute cost impact.

10/10High

Input Pins

5

Left

Generic Array

array_left

Left Array

Generic type enforced

Right

Generic Array

array_right

Right Array

Generic type enforced

Left Key

String

key_left

Field on the left elements, dot notation for nested fields. Empty uses the element itself

Right Key

String

key_right

Field on the right elements. Empty reuses the left key

Join

String

join

Inner keeps only matches, Left keeps every left element

Default Inner

InnerLeft

Output Pins

2

Pairs

Struct Array

pairs

One entry per match, holding both sides

SchemaJoinedPairJoinedPairJoinedPair1 fields

matchedbooleanrequired

Matched

Integer

matched

How many left elements found a partner

Node Info

Internal name

array_join_by

Category

Utils/Array