Compare Two fields in a single table

[gfisch13]

Compare Field Values in a single table

Hi Folks..........

I'm working on a project that is loading data from two sources, one is a bank account file, the other is a policy master file.

In my script these two tables are linked by policy number.

In QV, I have created the table box (attached) that includes one field from the bank account file (Bene) and several others from the policy master file (policynum, owner, age)

I want to analyze values where the Bene last name and the owner last name are different.   I'm unsure how to present this.

Any help is appreciated.

[gfisch13]

Hi Folks..........

I'm working on a project that is loading data from two sources, one is a bank account file, the other is a policy master file.

In my script these two tables are linked by policy number.

In QV, I have created the table box (attached) that includes one field from the bank account file (Bene) and several others from the policy master file (policynum, owner, age)

I want to analyze values where the Bene last name and the owner last name are different.   I'm unsure how to present this.

Any help is appreciated.

[bhargav_bhat]

Hi Fisch,

DO you want to have the only records in the table where there is a mismatch or you want to just highlight it keeping other records as well

Regards,
Bhargav

[gfisch13]

Just the mismatches please.
Thank you!

[bhargav_bhat · Accepted solution]

Try this expression

if (owner=bene, policynum)

and uncheck include null values

Regards,
Bhargav

[gfisch13]

thanks for the input Bhargav, right on point. My data needs some cleansing which will further improve the results!!