Multi-Join
The Multi-Join feature joins the unique rows from a set of multiple tables onto a set of common keys.
Unlike most table operations, Multi-Join is not a constituent method of the Table class; instead, it is an external function that takes tables as arguments. Also, unlike most table operations, Multi-Join does not return a table -- it returns a MultiJoinTable object, which in turn uses the table() method to return the underlying table.
Syntax
Parameters
| Parameter | Type | Description |
|---|---|---|
| keys | String[] | A String array containing key column names; e.g., |
| inputTables | Table... | Any number of tables to be joined together. |
| columnsToMatch | String | A list of key columns in string format (e.g., "ResultKey=SourceKey" or "KeyInBoth"). If there is more than one key, they must be separated with commas (e.g., Note
Like |
| multiJoinInputs | MultiJoinInput... | A list of |
Returns
A MultiJoinTable object.
Examples
In this example, we will create a MultiJoinTable using two keys and a list of three source tables.
In this example, we will create a MultiJoinTable using a list of MultiJoinInput objects.