Workflow Join Tools
Workflow Join tools enable you to combine multiple datasets using join, union, and other operations in Designer Cloud.
Join
Join 2 or more streams of data by appending data to wide/long schema.
Item | Description |
|---|---|
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. | |
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. | |
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. | |
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. | |
Use Union to combine 2 or more datasets on column names or positions. |