Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I need to view the ...
 
Notifications
Clear all

I need to view the common data between the two data sets that have been joined. How do I do this?

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

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

1672047160-join.png

Step 5: Click on Join and click on the settings icon.  

Step 6: A pop-up appears. The user can select the inner join option from the join type dropdown and make the connection between two tables. 

Step 7: Click on the save button. (Refer to the image below).

1672047225-innerjoin.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'. (Refer to the image below).  

1672047268-innerjoin01.png

Step 11: Click on 'Show Preview'.  

Step 12: The common data between these two tables will be shown in the 'Results'. (Refer to the image below).  

1672047300-innerjoin1.png

   
Quote
Share: