07-31-2023 02:17 AM - edited 07-31-2023 03:40 AM
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.
07-31-2023 10:45 AM
Hi @nikhil_cr
This video shows how you can use inQuery Incorta filter to show common IDs from two tables with no join
08-01-2023 11:31 PM
Thanks Mate @anurag