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 |
|---|---|
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 Fuzzy Match to identify non-identical duplicates of a dataset. | |
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 Make Group to take data relationships and assemble the data into groups based on those relationships. | |
Use Union to combine 2 or more datasets on column names or positions. |