topic Re: Comparing columns in 2 different tables in App Development

Comparing columns in 2 different tables

krishnagutha1294 — Thu, 01 Apr 2021 13:46:08 GMT

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 — Mon, 06 Jul 2020 11:40:35 GMT

can you share a sample data and the expected output ?

krishnagutha1294 — Mon, 06 Jul 2020 12:35:55 GMT

The result need as per attached table.

Vegar — Mon, 06 Jul 2020 14:07:55 GMT

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

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

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 — Mon, 06 Jul 2020 14:34:42 GMT

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"