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 is able to select 'Right join' in join type dropdown. Make the connection between the two tables.
Step 7: Click on save button. (Refer to the image below).
Step 8: Click on results and click on the settings icon.
Step 9: In 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 right table will be shown and from left table only common data will appear. (Refer to the image below).