Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I have selected the...
 
Notifications
Clear all

I have selected the join operator. How do I initiate left join operation?

1 Posts
1 Users
0 Likes
221 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  

Step 1: Click on the line and click on the settings icon. (Refer to the image below).  

1672047418-linesetting.png

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

1672047475-join.png

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

1672047543-leftjoin1.png

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

1672047612-leftjoin2.png

   
Quote
Share: