Welcome to the Datanyx Community!
Step 1: Click on the line and click on the settings icon. (Refer to the image below).
Step 2: Select the 'Join' operation in the popup.
Step 3: Drag and drop another dataset onto the main screen.
Step 4: Join dataset sheets with join operation. (Refer to the image below).
Step 5: Click on 'Join' and click on the settings icon.
Step 6: A pop-up appears. The user can select 'Left join' from the join type dropdown and make the connection between two tables.
Step 7: Click on the save button. (Refer to the image below).
Step 8: Click on results and click on the settings icon.
Step 9: In the configure popup select column name and display name according to the user requirement.
Step 10: Click on 'Save'.
Step 11: Click on 'Show Preview'.
Step 12: In Results, the total data which is in the left table will be shown and from the right table only common data will appear. (Refer to the image below).