<< Click to Display Table of Contents >> Current:  Advanced Analytics > Data Transformation  Join

Combine the output data sets of multiple nodes into one data set, similar to the join operation of multiple tables in a database.

 

How-To-Use:

The node input is connected to multiple nodes with data set output, and the output is a data set.

 

Precautions:

The front node must be able to output data sets.

❖Configuration

After adding the Join node to the experiment, you can set the Join node through the "Configuration" page on the right.

[Join method] There are two combination methods: full join and inner join. inner join: the combined result only contains rows that match the index; full join: the combined result retains the rows that do not match the index.

[Duplicate name field processing] Two options: 'suffix with node name': use node name as field suffix, the format is "field name_node name"; 'raise error': do not process, if the field name conflicts, terminate the execution and prompt.

 

Right-click menu of Join node:

❖Run Join Node

Run the node, pass the data to DM-Engine for calculation, and get the output result.

 

❖Reset Join Node

The node that has been running is reset, the returned result is deleted, and the node status is changed to not running.

 

❖Rename Join Node

In the right-click menu of the Join node, select "Rename" to rename the node.

 

❖Refresh Join Node

In the right-click menu of the Join node, select "Refresh" to update the synchronization data or parameter information.

 

❖Save as Composite Node

In the right-click menu of the Join node, select "Save as Composite Node", and the selected node can be saved as a composite node to realize a multiplexing node, and the parameters of the saved node are consistent with the original node.

 

❖Cut Join Node

In the right-click menu of the Join node, select "Cut" to realize node cutting operation.

 

❖Copy Join Node

In the right-click menu of the Join node, select "Copy" to realize node  replication operation.

 

❖Delete Join Node

In the right-click menu of a Join node, select "Delete" or click the delete key on the keyboard to delete the node and its input and output connections.