Comparing columns in 2 different tables

[krishnagutha1294]

Hi All

Having 2 different tables

1st table having fields  A,B,C

2nd table having fields D,E,F,G

Need to write set analysis Expression for comparing (a=d or a=e or a=f)after satisfying the above condition then get  count (A).

Please any one solve the above expression.

Thanks in Advance.

[Taoufiq_Zarra]

can you share a sample data and the expected output ?

[krishnagutha1294]

The result need as per attached table.

[Vegar]

You might solve this by using multiple implicit set analysis modifiers like this. 

Count ({<A=p(D)+p(E)+p(F) >} A)

or

Count ({<A=p(D)>} +{<A=p(E)>} +{<A=p(F) >} A)

or similar.

I hope this helps you or at least points you to in a good direction.

- Vegar

[Kushal_Chawda]

You can add A,D,E & F fields in dimensions and put below expression

=if(A=D or A=E or A=F,1,0)

You can go to Add-on and uncheck  " Include zero values"