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