cancel
Showing results for 
Search instead for 
Did you mean: 

VLOOKUP In Incorta ?

nikhil_cr
Cosmonaut

nikhil_cr_0-1690794898984.png

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.

2 REPLIES 2

anurag
Employee
Employee

Hi @nikhil_cr 

This video shows how you can use inQuery Incorta filter to show common IDs from two tables with no join

https://youtu.be/vx7B18m3xLI

 

nikhil_cr
Cosmonaut

Thanks Mate @anurag