Author: Kepion Product Team
The Join Component allows for complex join conditions. There are numerous areas where you can add additional layers of customization to the operation.
The first area to customize is the drop-down. Click the box to select an operation to override the default selection.
In addition, click to define your own custom join expression:
Select Custom from the Configure drop-down, and design your join own join expression: