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.

Find Replace 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.

Union Tool

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