Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following problem for which I couldn't find an answer:
Simply put I have two tables, say:
Table A:
Load
F1, F2, F3
from (some QVD table);
Table B:
Load M1, M2, M3
From (another QVD table);
I want to show a KPI:
=count({$}<exists(F1 in table B)>)F2
That is I want to show how many F2 I have in table A where F1 exists in Table B (usually in the coloumn M1).
What is the best way to achieve this?
Thanks,
Zohar.
Typically, the best way to approach this would be to link the tables, use a mapping load or otherwise adjust the schema to fit the data together.
If that isn't feasible for some reason, you could try something like:
Count({< F1 = p(M1) >} F2)
p() is the set of possible values
Typically, the best way to approach this would be to link the tables, use a mapping load or otherwise adjust the schema to fit the data together.
If that isn't feasible for some reason, you could try something like:
Count({< F1 = p(M1) >} F2)
Hi, Thanks for your reply. I am not sure I understand, what do you mean by p(M1)? Is this a function, a modifier or what? Thanks for clarifying.
Zohar.
p() is the set of possible values
Thank you so very much. You helped me solve my problem.