Skip to main content

Workflow Join Tools

Workflow Join tools enable you to combine multiple datasets using join, union, and other operations in Designer Cloud.

Workflow Join Tools

Item

Description

Append Columns Tool

Use Append Columns to append every row from a source dataset to every row of a target dataset. This operation is also known as a cross join.

Append Columns Tool

Use Find Replace to find a string in 1 column of a dataset and look up and replace it with another string. You can also use Find Replace to append columns to a row.

Join Tool

Use Join to combine 2 inputs based on common columns between the 2 tables. You can also join 2 data streams based on row position.

Join Multiple Tool

Use Join Multiple to combine 2 or more inputs based on a commonality between the input tables. By default, the tool outputs a full outer join.

Make Group Tool

Use Make Group to take data relationships and assemble the data into groups based on those relationships.

Union Tool

Use Union to combine 2 or more datasets on column names or positions.