Hey Chris,In Sparkflows, we can use the ‘Join On Common Columns’ and ‘Join On Common Column’ processors to join multiple datasets. ‘Join On Common Columns’ processor can be used to join based on multiple columns and ‘Join On Common Column’ can be used to join on a single common column.
To use the ‘Join On Common Column’ Processor:
- Select a column ‘Common Join Column’ field. It would be common among all the incoming datasets. It would be used to join datasets.
- Select ‘Join Type’ from the list. It can be ‘inner’, ‘outer’ and so on. This specifies how incoming datasets would be joined.
For more information read the Sparkflows Documentation here:
- Select one or multiple columns in the ‘Common Join Columns’ field. They would be common among all the incoming datasets. They would be used to join datasets.
- Select ‘Join Type’ from the list. It can be ‘inner’, ‘outer’ and so on. This specifies how incoming datasets would be joined.
For more information read the Sparkflows Documentation here:
Hey Chris, In Sparkflows, we can use the ‘Join On Common Columns’ and ‘Join On Common Column’ processors to join multiple datasets. ‘Join On Common Columns’ processor can be used to join based on multiple columns and ‘Join On Common Column’ can be used to join on a single common column.
To use the ‘Join On Common Column’ Processor:
- Select a column ‘Common Join Column’ field. It would be common among all the incoming datasets. It would be used to join datasets.
- Select ‘Join Type’ from the list. It can be ‘inner’, ‘outer’ and so on. This specifies how incoming datasets would be joined.
For more information read the Sparkflows Documentation here:
https://docs.sparkflows.io/en/latest/user-guide/data-preparation/join-union.html?highlight=join%20on%20common%20column#join-on-common-column
To use the ‘Join On Common Columns’ Processor:
- Select one or multiple columns in the ‘Common Join Columns’ field. They would be common among all the incoming datasets. They would be used to join datasets.
- Select ‘Join Type’ from the list. It can be ‘inner’, ‘outer’ and so on. This specifies how incoming datasets would be joined.
For more information read the Sparkflows Documentation here:
https://docs.sparkflows.io/en/latest/user-guide/data-preparation/join-union.html?highlight=join%20on%20common%20columns#join-on-common-columns