How do I fetch the common values (Cluster ID) between these tables (See Snip)? Basically I want to have one more table and show the values (Cluster ID) that are common from both the tables.
As you can see Cluster ID - 1063 is present in both the tables and I want to show all the common values between these tables in a single column in a different table. Just like a VLOOKUP function in Excel.
NOTE: There is no JOIN between table 1 and table 2.
Solved! Go to Solution.