Join Data Tables
Joins two data tables on specified columns
Input
Join Tables
| Name | Required | Description |
|---|---|---|
| Left Table | Select the left table for the join operation. | |
| Right Table | Select the right table for the join operation. | |
| Join Type | Select the type of join you want to perform. | |
| Left Key Column | Enter the name of the column in the left table that will be used as the key for the join. | |
| Right Key Column | Enter the name of the column in the right table that will be used as the key for the join. | |
| Normalise Join Values | When evaluating a join, the values will be compared as case-insensitive and trimmed strings. |
Output
JoinResult The resulting data table after the join operation