Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a dashboard with 2 excel tables in the contents (Table 1 and Table 2). I need to do some KPIs, summarizing, values from table 2, but just the ones that belongs to a list of people in Table 1. The field that I need to use to compare between 2 tables is the "key" between the tables. Is there any way or formula I can use to do that conditional exercise.
Is it clear? Can maybe I build a new table from the 2 existing ones?
Thank you!
Hi, one approach is with Exists():
Tabe1:
LOAD key as KeyToCheck
From abc;
Table2:
LOAD Key,
Value,
...
From xyz
Where Exists(KeyToCheck,Key); /*Checks if the "Key" in Table2 exists in "KeyToCheck" from Table1*/
DROP Table Tabe1;