how to Compare two tables value?

[narender123]

Hi All,

I have two tables suppose "Table A" with column "taxpair","taxno","Amount" and "Table B" with column "taxpair".I want to show the result like

if(taxno=1 and value of taxpair of table A is present in table B taxpair values then show "Individual"

but if(taxno=1 and value of taxpair of table A is not present in table B taxpair values then show "Individual-Enterprise"

?????????????

Thanks in advance.

[#2]

Hi,

I would suggest a new idea:

Try to research alternate states.

With set analysis and states you can compare 2 kinds of tables. Let me know if you require an example document.

Kind Regards,

Dion

[narender123]

Yes .I need your help.So its better if you give me the example please.

Thanks.

[#4]

Hi,

please try this expression instead

if(taxno=1 and taxpair=taxpair2,'indivdual',(if(taxno=1 and taxpair<>taxpair2,'individual-enterprise',if(taxno=2,'property',if(taxno=3,'enterprise'))))) as new

in the Mohit's qvw.

It's working fine as per your requirement.

[narender123]

Hello Kumariysns,

I have done with your expression but its not working for taxpair=taxpair2.

See the attachment below.

[#6 · Accepted solution]

Hi Narender,

It's working fine for me, plz check out the below attachments.

[narender123]

Thanks Kumariysns..