Create Join Node

A join node requires you to specify two or more data source nodes and at least one output column.

Joins are sometimes very slow; if you materialize the join input as an indexed table, as described in Create Table or View Node, the join may be much faster.

The output of Join is a data flow. If you want to materialize it as a table or view, connect it to a Create Table or View Node.

Follow these steps to join two or more data sources:

  1. Identify or create at least two nodes to join. The nodes can be any nodes that provide a data flow, including Data Source Nodes.

  2. If the Components window is not open, open it using View > Components. Expand the Transforms section.

  3. Click Join. Move the cursor to the workflow; click again.

  4. Connect the data sources to be joined to the Join node:

    1. Move the cursor to one of the nodes to join.

    2. Right-click the node, and select Connect from the context menu.

    3. Draw a line to the Join node; click again.

    4. Repeat until all nodes to join are connected to Join.

  5. Right-click the Join node; select Edit. Use the Edit Join Node dialog to define the Join.

  6. Right-click the Join node; select Run. Monitor the node execution in the Workflow Jobs. If the Workflow Jobs is not open, open it using View >Data Miner> Workflow Jobs.

  7. After the execution completes, right-click the Join node and select View Data to view the results of the join.

You can also define the join and view results using the Join Node Properties.