- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-01-2023 11:31 PM
Thanks Mate @anurag
