Compare the data and then count

[varunreddy]

Hi All,

I am trying to lookup if the same data from one table A is available in table B and trying to count it.

For example

Table A has 10 values and Table B has 5 values and 3 values are in common. I want those three values. I have tried few things, but it is not working.

The expression I am trying.

=Count({<[ID] = {"=only({<['A'] = 'A'>}[ID]) = =only({<['B'] = 'B'>}[ID])"}>}[ID])

Attached source file and QVW for reference.

Thanks in advance!

[antoniotiman · Accepted solution]

Hi Varun,

See Attachment.

Regards,

Antonio

[sunny_talwar]

This can also work

=Count({<ID = {"=Only({<['A'] = {'A'}>}ID) = Only({<['B'] = {'B'}>}ID)"}>}ID)

[varunreddy]

I tried it, before posting. Not sure why it didn't work

[varunreddy]

Thanks for your response.

Cheers,

VK

[varunreddy]

Sunny,

Thanks for your response again.

I used the same expression but used two equal to signs

Cheers,

VK