Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
The data cube that ...
 
Notifications
Clear all

The data cube that I have created is now inner joined. How do I change the join type to right join?

1 Posts
1 Users
0 Likes
224 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).  

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

1672047794-join.png

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

1672047838-rightjoin.png

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

1672047924-rightjoin1.png

   
Quote
Share: