topic Re: VLOOKUP In Incorta ? in Dashboards & Analytics Discussions

VLOOKUP In Incorta ?

nikhil_cr — Mon, 31 Jul 2023 10:40:04 GMT

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.

Re: VLOOKUP In Incorta ?

anurag — Mon, 31 Jul 2023 17:45:22 GMT

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

Re: VLOOKUP In Incorta ?

nikhil_cr — Wed, 02 Aug 2023 06:31:45 GMT

Thanks Mate @anurag