Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
05/01/2023 12:29 pm
The user can join two data sets/ tables. The user is able to select from the join types available.
Step 1: Once the data sets are imported, click on transformation.
Step 2: Drag and drop the merge node onto the main screen. Connect the nodes. (Refer to the image below).
Step 3: Once a successful connection is made between ‘data import1, data import2 and merge’, click on the select button. A pop-up appears with the columns present in the data.
Step 4: The user is now able to select the dataset, join type and join condition.
Step 5: Click on ‘Apply’. (Refer to the image below).
Step 6: Once the columns and the operations that need to performed have been selected, click on the run button or the merge node twice to run the workflow. Click on the icon in the bottom line. (Refer to the image below).
Step 7: The data is reflected based on the operations selected. (Refer to the image below).
Note: The user can run the workflow for individual nodes as well.